Update Current Record Only

B

Bill

How do I update the current record only on a form and not update
succeeding records when I navigate to them? I have a date field that I
want to update to the current date and when I move to the next record,
I want to see it's original value.

I created a macro using the Date() function and it works except that
succeeding records are changed as I move to them.
 
A

Arvin Meyer [MVP]

Use: =Date() in the DefaultValue property of the table and/or form and it
will only affect new records. For any other records in form view, only 1
bound field is affected. If the textbox is not bound to the underlying field
in a datasheet or continuous form, changing a value affects all rows.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update a Current Record Only 1
Current date and time default? 2
Update old record date when user click on D_Status 1
Requery of Accumulator Control on Form 1
Logging last update for a record 4
Display Current Record and Total Records 4
Update many fields of the CURRENT record of a subform 4
Time Stamp 1

Top