I want to be able to record the date in a text box whenever someone makes any changes in any of the forty text boxes on my form. Can anyone give me some advice.

Private Sub Form_BeforeUpdate(Cancel as Integer)

txtDate = Date

This will not change the date automatically when the data is changed, but it will record a new date when the record is saved.

Keagan Quilty
Kilbride, Newfoundland