Capture Date when record is edited 2

[Quintios]

I have a database where the records are often edited. When reports are printed out, folks need to know if they have the "latest and greatest", so I include the "RevisionDate" in the report.

Up until now, I've been clicking in a box to capture =NOW(), but I'd like to do this automatically whenever a field in the record is edited or updated.

How would I accomplish this?
Onwards,

Q-

 

[SgtJarrow]

If you have a particular field that will flag the record as being updated, then you can use the after update of that field with:

Me![Name of field] = Now()

Also, could probably use the afterupdate event for the entire record (form).
If we knew what it was we were doing, it would not be called research, would it? - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[jebry]

Hi!

In the before update event for the form use the following:

YourDateField = Now()

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Quintios]

Thanks to both of you! One star each!
Onwards,

Q-