Update another table when data entered into current form

[Fireman1143]

Part of my applicaton has a table in which I would like to have the one field - fldCompleted - filled in with a date when a form attached to another table has the Completed Date filled in.

The form has two hidden fields which can be used for matching the table with the fldCompleted. I have been looking at using an OnChange event but can not decide if a macro or coding would be the best.

 

[BSando]

What I have done in the past is create a Macro using "SetValue".
In Item put in the field name from your form [forms]![form Name]![field name]
In Expression: now()

In the field on your form that you want to trigger the update use the "After update" and select you macro. This will enter todays date when ever the field comments for example is updated.

Some people make things happen, some watch while things happen, and some wonder 'What happened?'