L loki Registered User. Local time Today, 11:57 Joined May 4, 2001 Messages 58 Aug 9, 2001 #1 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.
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.
K KeaganQuilty Registered User. Local time Today, 08:27 Joined Jun 28, 2001 Messages 51 Aug 9, 2001 #2 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
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
