Correct use of Dirty event

[Ericks]

I have a subform that contains several controls of which one is a date control called “DateOfInfoAdded”. The default format of this control is date() so whenever a new record is created the date is automatically set to today. But when controls on the form are edited I want a message to appear asking whether this date should be changed (to now indicate the date of editing). I know that the dirty event is involved but I wouldn’t know how and where to use it (on dirty, before update, after update, etc.of the form, the controls?) as well as how to refer to the date control to change. Certainly a piece of cake for you guys.

[Ericks]

Well, I came up with something completely different but it seems to work. In the After update event for each control (don't laugh) I added this code:

If Me.[DateOfInfoAdded] < Date Then
Save_Response = MsgBox("You have edited the data. Do you want to change the date to today?", vbQuestion + vbApplicationModal + vbYesNo, "Save Record?")
If Save_Response = vbYes Then
Me.[DateOfInfoAdded] = Date
End If
End If

The first line is to avoid to be asked the question if the edit date is the same as the [DateOfInfoAdded].

Not "elegant" is that I put this code behind each control. When I put it in the Form's event it will trigger the message twice because it will flag the date change itself.

I'm sure the Dirty event is the right way to go so I'm still open to suggestions.