macro conditions

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

Guest

I have a query that counts the number of books on a shelf and returns this one value. I would like to set up a macro that displays a message box ( stating the shelf is full) when the value the query returns = a given value ( this is my condition statement
is this possible or will i have to send the information to a report or query?
 
Nicole,

You could use something like this in the Condition of the MsgBox action
in your macro...
DLookup("[YourCount]","YourQuery")>=111
 
Back
Top