Steve,
Fair enough. The problem I had was "I am not having any joy" in your
original post did not give me much of a handle on the nature of the problem.
Ok, if you are going to store the date that a record is modified, then
you will need a field in your table where this can be stored. This will
be the table that your form is based on. So, go to the design view of
this table, and add a new field and name it DateModified. Make it a
Date/Time data type. Ok?
Go to the design view of the form, and look at the Properties. What is
shown in the Record Source property? Is it the table, or does it show
the name of a query? If it's a query, you will need to go to the design
view of the query, and add the DateModified field to the query grid.
Add a new textbox to the form design. Look at the Properties of the
textbox. In the Control Source property, enter the name of the new
field you have just added i.e. DateModified, and also change the Name
property to DateModified.
Open a new Macro in design view, and create it as described before. In
other words, enter SetValue in the Action column, and then in the
properties boxes down below, enter like this...
Item: [DateModified]
Expression: Date()
Close and save the macro.
Back to the design view of the form, look again at the Form properties.
Find the Before Update property. Enter the name of the macro you just
created.
Close and save the form.
Open the form in Form view, change the data in one of the records.
Close the form. Open the table and see if today's date has been entered
into the DateModified field for the record you edited
