What is the correct syntax? (1 Viewer)

[crhodus]

I have a form that contains the code Me.LAST_UPDATED = Now()
in the BeforeUpdate property. It records the last time and date that data in the 'COMPANY' table has been added or modified.

I want to do the same thing in another form called PARENT_INFO. I want the date and time also stored in the LAST_UPDATED field of the 'COMPANY' table.

I tried entering in
Me.[COMPANY].[LAST_UPDATED] = Now()
but it is trying to record the data to a form. What is the correct syntax to record the data to a table?

Thanks!

 

[Rich]

Use an update SQL or query.