Modify date in an existing field.

Topic

New Reply

Easy code question.
TableA has a Refdate field set to default date. I want to change the Refdate to today’s date when the record is modified.
In the data entry form I need to create a Before Update event procedure to change the date.
Could someone help me with the code. I just can’t do it.
Thanks

Reply | Quote

Replies

Attach the following to the Before Update Event of the form:

If Me.Dirty Then
Me![RefDate] = Date
End If

The Dirty property determines whether the current record has been modified since it was last saved.

Reply | Quote

Two things – Me.Dirty is only available in Access 2000 (the original questioner didn’t say what version of Access they were using). Secondly, the beforeupdate event won’t fire if the record hasn’t changed, so you don’t really need to check me.dirty in the beforeupdate event.

Reply | Quote

Sorry, but Me.Dirty has been around since at least Access 97. I can’t remember whether that property was exposed in earlier versions or not.

Reply | Quote

Oops! I was about to argue with you until I realized that I was confusing the Dirty event (new in Access 2000) with the Dirty property. Sorry.

The rest of my comment still stands. If the form isn’t “dirty” the beforeupdate event won’t fire, so there’s no need to check if it’s “dirty”.

Reply | Quote