get MS Access 2010 to stamp the actual date on a field created for this purpose

[luisalbertopr]

I have an Access 2010 database which I'm trying to get it automatically stamp the date when specific field is populated or modified.

[Rabbit]

Use the on change event of the control in the form to run VBA code that will update the time stamp field.

[luisalbertopr]

Thank you Rabbit for your response. But, can you be more specific. I'm a newby. I tried some options but cannot get the expected results. Thank you, again.

[Rabbit]

In that case, what you'll want to do is look into a VBA tutorial because I don't think there's any other way to do this without code. Once you have that foundational understanding, we can get into the specifics of this problem.

[luisalbertopr]

Thank you Rabbit. That's what I'm doing right now. It seems to be a simple task, however maybe it does need to write some code in order to get what I want to perform.

[nico5038]

I would use the form's BeforeUpdate event like:

Private Sub Form_BeforeUpdate(Cancel As Integer)

If Me.FieldName <> Me.FieldName.OldValue Then
   Me.LastUpdated = Now()
End If

End Sub

For the BeforeInsert you could use a test for the field being filled (<> "") when you want the initial filling recorded too.

The LastUpdated field can be placed hidden on the form.

Nic;o)