Update field

J

Jason

I've got a field - LastModified - that I'd like to display
when the current record was last modified. The data is
displayed on a form in Continuous Forms view. What is the
best way to update the LastModified field to the current
time when the current record is modified?

Thanks in advance,

Jason
 
D

Douglas J. Steele

Add code in the form's BeforeUpdate event to set the LastModified field
before you save the record.
 

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

Split form 0
How do I clear a form? 0
Duplicate record in Form and Subform 0
looking for a way around a write conflict... 2
write conflicts 1
date of last data change 3
Copy previous record into form field 0
Adding data to MS Access from csv file 0

Top