SET VALUE for Modified Date Record

  • Thread starter Thread starter Ted Steinberg
  • Start date Start date
T

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
 
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.
 
Back
Top