Discussion Locked

Access 97 Field update

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a date and time field that I want updated with the current system date and time, by clicking a command button. Any suggestions?

3 replies

by mbarker734

Asumming the the field name on the for is Current_Date.

Modify the coding within any command button to include:

me!Current_Date = Now() used in conjuction with the on click Event Procedure will set your field to the current system date and time.

Then simply change the text on the button to display what you want.

This discussion is closed to new replies.