Can a condition in a macro close a query?

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

Guest

I'm trying to automatically close a query if it's result returns zero
records. I have many queries running in one macro - not all will return
results all the time so i want to automatically close those with no results -
but i do want to run them.
What can i put in the conditional statement. I've tried and if statment but
i get an error.
 
In your conditions area of the macro on the line that runs
the query
DCount("*", "queryname") > 0

Chris
 
Back
Top