I have a single table MSAccess database with one form, which the user enters data about each client. I have a field called date_last_updated which has datatype general date.

When the user clicks AddRecord command button, I want the current date\time [now()] entered into this field.

Also if the user updates an existing record and clicks the saverecord button, I want the field [date_last_updated] to update to the current date\time.

Not so good with this stuff yet. Thx, bph

Set the fields default value to Now().
Create a different field for keeping when the record was entered an another for when the record was changed. To make sure that the date_last_updated field gets a value every time is changed use ado and set the value for the field to Now().



Sal

Thanks! I'll look up the ado stuff and figure that out.

Hi BPH,
You can also, on the BeforeUpdate event of the Form, you can put...

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Date_Last_Updated.Value = Now
End Sub

Or, If you made the command buttons yourself...

Private Sub cmdAddRecord_AfterUpdate()
Me.Date_Updated.Value = Now
End Sub

Hope this helps, good luck!

Now, that is even easier. I learn something new every day.



Sal

[quote]Originally posted by DBoulos
 Hi BPH,
You can also, on the BeforeUpdate event of the Form, you can put...

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Date_Last_Updated.Value = Now
End Sub

Or, If you made the command buttons yourself...

Private Sub cmdAddRecord_AfterUpdate()
Me.Date_Updated.Value = Now
End Sub

Hope this helps, good luck!


[/Thanks]:)