Macro not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a Macro for a Conditional Expression. The form is named 'Flag Time
Frame'. I would like it to setvalue using a checkbox if the dates in the
"Answer" column are 45 days or old.

My condition is: [Forms]![Flag Time
Frame]![MDateRecvdfromReq.Answer]<Date()-(1*45)

Item: [Forms]![Flag Time Frame]![Over 45 Days]
Expression: Yes

When I try and run the Macro I receive this error:

Microsoft Access Can’t Find the form ‘Flag Time Frame’ referred to in a
macro expression or Visual Basic code.

*The form you referenced may be closed or may not exist in this database.
*Microsoft Access may have encountered a compile error in a Visual Basic
module for the form.

Can anyone help?
Thanks so much,
Cathy
 
Cathy,

Is the "Flag Time Frame" form open at the time that you run the macro?
Where is the macro triggered from, and what event?
 
Back
Top