Msg Box will not display

  • Thread starter Thread starter Robert
  • Start date Start date
R

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...
 
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()")
 
Back
Top