How to test if a query is empty

G

Guest

In a Form, i run a query, if the query result is empty, put true in a checkbox, else false.
thank u..
 
K

Ken Snell

Check out the DCount function. It will return the number of rows in a query
or table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Uncheck all checkboxes on update 1
How prevent typing in datasheet depending on other field 1
set field to empty upon condition 4
Check box issues 2
Form not displaying fields when query empty 2
Access Determine what query to run based on a checkbox 0
Turning On controls 1
Can Checkbox return any other value ? 2

Top