MACRO QUESTION

  • Thread starter HOW DO I CREATE A SEARCH FORM????
  • Start date
H

HOW DO I CREATE A SEARCH FORM????

HI,

I've created a "send object" macro that sends me an email based on a query
every time i open the main form. Now my question here is: how do i make it so
it only sends me the email when there are records in the query? (the query
is to remind me when corporation returns are due and it usually shows no
records)

thanks
 
S

Steve Schapel

Use a Condition for the macro. If you can't see the Condition column in
the macro design window, select it from the View menu. The Condition
will look something like this...
DCount("*","YourQuery")>0
 
Top