VBA code to update field in table

[vickan240sx]

Hi,



I am currently trying to add a last updated field for each field on my table. I figure I would have to add a before update code for each field on my form. However, the field that I want to have updated is not located on my form, but just on the table. I would like to have the field on the table updated with the last user and time the field was updated.

Any help will be greatly appreciated.

[John_G]

As long as the table field is included in the recordsource for the form, you can update it without needing a control on the form.

[TableFieldName] = somevalue works fine, but you will need VBA to do it, and either the Before_Update or After_Update event is a good place.
Just be sure you don't accidently have a form control name the same as one of the table field names.

John