Macro not working

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
 
S

Steve Schapel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top