I'd be glad to help, but I'll need some more detail from you.
Are you getting an error message? If so, what is it?
Or is it that you are unsure of how to insert code behind an event? Here's
some detail on how to do that:
Open your form in Design View, then:
1. Press ALT-Enter to open the Property Sheet for the form.
2. You will see another form with a ComboBox at the top which says "Form".
Leave that one alone. Below the ComboBox is a set of Tabs. Click the one
that says "Events".
3. In the grid below, locate the row labeled, Before Update. It should be
blank. Click anywhere in the white space to the right of the label and you
will see a downward-pointing arrow appear, indicating that this is also a
ComboBox. Click the arrow and select "Event Procedure".
4. Then, notice that there is an ellipsis or three little dots (...) to the
right of the ComboBox. Click the ellipsis and you will open a code window.
You will see that Access has given you a space for entering some code in
this event - it will look something like the following:
Private Sub Form_BeforeUpdate(Cancel As Integer)
End Sub
The Before Update event will "fire" just before an Edited Record is saved to
the
database, so you will want to update the DateUpdated field on your form.
5. After the "Private Sub Form_BeforeUpdate(Cancel as Integer)" line,
insert the following code:
me!DateUpdated = Date()
Save the module. Then, click on the Debug menu item in the code window and
select Debug. If the debug produces no errors, just close the module.
hth,
