Date Update to Current Date

[JackG]

I'm using A2K and very new to Access. I want to have a text box (with a control source) update itself with the current date when any change is made to the current record.

I read somewhere in here that the "Dirty" command could do something like that but there was not enough info there for me to act on.

Thanks in advance for your wisdom!

 

[JackG]

I'm doing something wrong...

I put the following in the properties for the text box. An error says it can't find a Macro??? What am I doing wrong? I'm new to the code stuff. Thanks....

--------------------------------------------------------------
Private Sub dtmUpdateDate_BeforeUpdate(Cancel As Integer)
Me.LastUpdateDt = Now()

End Sub
--------------------------------------------------------------

 

[JackG]

That did it... Thanks
Evidently I can't read either

 

[benjee]

following on from your thread guys,

how can do you implement a 'todays date/ time' function when a new record is added rather than a field that has been amended?

 

[benjee]

Thanks Pat i will try that today.

Yeah on the form load up i want the current date to display in a text box, and update every day.

You say the columns update property? is that the text boxes before update property i.e.

Private Sub Text7_BeforeUpdate(Cancel As Integer)
Me.Text7 = Now()

or have i got the wrong end of the stick?