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!

 

[Pat Hartman]

Put the code in the BeforeUpdate event of the Form.

Me.LastUpdateDt = Now()

 

[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
--------------------------------------------------------------

 

[Pat Hartman]

You need to put the code in the BeforeUpdate event

of the Form

. Also, you need to use your own column name. Change "LastUpdateDt" to whatever your column name is.

 

[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?

 

[Pat Hartman]

If you only want to populate the field on "add" and never change it, put
Now()
in the table column's default property.

 

[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?