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
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