Counting Records in a Query Using Code

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I have a form my sales guys can use to enter booth change requests. I have a
button on the form to gather new change requests in a query, send them out in
an e-mail, and then update the records as sent. If there are no records in
the query, I want it to show a dialog box instead and not send anything.
What's the easiest way using code to tell if the query is empty?
 
Back
Top