Update a Current Record Only

B

Bill

How can I update a Date field on a Form to the current date and update
the field on the underlying table for just the current record? When I
navigate to the next record using the form, the date field of every
record that I navigate to is changed as well. I only want to update
the current record and when I navigate to the next record, I want to
see it's original value.
 
G

Guest

One way is to use the double click property on the form field to call a macro
to SetValue and it will set the date to that field for that record only.
 

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 Current Record Only 1
Record count incorrect when a record has multiple attachments 3
Logging last update for a record 4
Current date and time default? 2
modified update 2
Update old record date when user click on D_Status 1
After update question 2
Display Current Record and Total Records 4

Top