Auto updating date field (2000SR1)

Topic

New Reply

A repeated query because I’ve lost the original data: on a form I have a record date field that I want to be updated with today’s date when the form is changed… help please (and I promise to copy and save the data somewhere else this time )

Reply | Quote

Replies

>>I have a record date field that I want to be updated with today’s date when the form is changed.<<

In your form's BeforeUpdate Event, just put in code like this:

txtLastUpdated = Date( )

Use Date( ) for just the date, use Now( ) if you want date and time.

Reply | Quote

Many thanks for that Mark – excellent help.

Reply | Quote