Help With Auto Update for Date field

[wolfegirl04]

Hi,

I made a very simple database to keep address for various businesses that we deal with on a regular basis. I have one form for data entry. I have a filed called "Date Updated". I would like this field to be automatically updated (with out me having to type in the days date) to the day the information for that record was added, changed or updated.

Can anyone help with a detailed step by step "How To"?

Thank You

 

[MadMaxx]

If you have a button that the user presses you can add the code the the OnClick event

Datefield = FormatDateTime(Now(), vbShortDate)

or if you don't have a button you can add it to one your text boxes OnChange event.