Question Locked

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

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

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

This discussion is closed to new replies.