Timestamp

[tmarsh]

In the before update of my data entry form I have Me.LAST_MODIFIED = Now which gives date and time when the record is modified. (LAST_MODIFIED is a field in my query set to date/time). The form has a subform - main form has staff details and the subform has training done.

It works OK on the main form if I make changes but not if I input data into the subform. How can I fix it?

Thanks.

 

[Oldsoftboss]

Cant you put:

Forms!ParentFormName.LastModified = Now

in the Before update event of the subform?

Dave

 

[tmarsh]

Cant you put:

Forms!ParentFormName.LastModified = Now

in the Before update event of the subform?

Dave

That gives a run time error 2465.

 

[Oldsoftboss]

Run Time Error 2465:

Microsoft Access can't find the field '|' referred to in your expression.@You may have misspelled the field name, or the field may have been renamed or deleted.

It is saying it cant find the field.

Try different syntax's, such as Forms!ParentFormName!LastModified = Now

Dave