Msg Box will not display

[Robert]

I have a message box based upon this condition

DLookup("[fieldname]","tablename"=Date()

When using the step method in macro objects, I get a true
answer that returns. But, when activated on open report,
the message box does not display.

Any help is appreciated...

 

[tina]

if the syntax you entered matches what's in your macro,
then it appears the syntax is your problem. try this:

DLookup("[fieldname]","tablename","[datefieldname]=Date()")