Questions

Access: how can I set the date and time when a record is saved in a form?

Tags:
+
0 Votes
Locked

Access: how can I set the date and time when a record is saved in a form?

Manuelleon
hi, could you please help me? I need to keep the record when a form is saved on access. I know how to save the time and date when a new record is open but what I need is to keep the record of date and time when the form is saved.
  • +
    0 Votes
    Tony Hopkinson

    On a new record you'd set your date time column to now.
    On an update you set it to now.
    Pick a suitable event. BeforeRecordUpdate, should do it.

  • +
    0 Votes
    Tony Hopkinson

    On a new record you'd set your date time column to now.
    On an update you set it to now.
    Pick a suitable event. BeforeRecordUpdate, should do it.