Help with Date Modified Macro and putting into data-entry form

  • Thread starter Thread starter FairContract
  • Start date Start date
F

FairContract

I'm trying to add a field into a form that I use that automatically adds the
date on which the record was modified and displays it on the form. I would
like to then create a report where only records updated in the last month
display.

I tried to follow the MS tutorial "Store the date and time when a record is
modified" which is located here:
http://office.microsoft.com/en-us/access/HA102412841033.aspx

Unfortunately it didn't work. The confusing part is where it says down in
the third part of the instructions (where it tells you how to put the field
and the macro into the form) step 5 tells you "On the property sheet, make
sure that the Selection Type is set to Form.

Tip To change the Selection Type, click the selection type you want in
the drop-down list."

I have no idea what that could be referring to.

My Macro looks like this:
Action: SetValue
Arguments:
Item: [Date Modified]
Expression: Date()
 
FairContract -

The Selection Type drop-list is the very top one on the properties dialog
box. You can also get there by clicking in the top-left corner box of the
form to select the form. You want the code to go in the BeforeUpdate event
of the form, (not the BeforeUpdate event of any of the controls on the form).

Hope that helps!
 
Back
Top