SET VALUE for Modified Date Record

[Ted Steinberg]

I have a Form generated by a Query which has a "Modified
Date" field (last date record was modified).

I generated a SetValue with:
Item: [Forms]![frmADDRESS]![dtmDateModified]
Expression: Date ().
I attached the macro to 'After Update'.

The macro does change the date; however, the form stays in
the edit mode (pencil icon in the left corner) & does not
allow me to move to the next record without hitting the
ESC key, which erases the new date.
Would appreciate any inputs?
Thanks,
teds

 

[Steve Schapel]

Ted,

The Item does not require the form qualifier. Just like this...
Item: [dtmDateModified]
There should not be a space in the Expression. Just like this...
Expression: Date()
The macro should go on the Before Update event, not After Update.