track changes in a subform

[RickB]

I am able to create a time stamp field as described in the Knowledgebase
document:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

However, my data entry form has a subform within it. The above process works
great if I modify an entry made in the main form. The problem arises if I
try to modify anything in the subform.

Any suggestions?

-rick

 

[Rick B]

You would have to apply the code to the subform events. You'd also need to
make sure the table to which your subform is bound, has your timestamp field
in it.

Pretty much every table you want to log timestamps for would need the field,
and all the associated forms and subforms would need to update that field
when a record is changed.

Rick B

 

[Rick B]

Ooh - after looking at your message again and the associated KB article, I
am not sure now if you are trying to track changes (save before and after to
an audit trail table) or simply update a timestamp (enter a date and time in
a field each time a record is changed).

Time stamp and audit trail are two different things.

Rick B