What is a good criteria 1

[downtime]

During a query I want the user to no if there where no records matching the criteria, instead of a blank results.
Any suggestions?

 

[grnzbra]

Is he running the query directly or is he running a report based on the query? If he's running it directly, what form did you want the notification to take?

 

[downtime]

If he is running it directly and I would like a pop up or just a generic form.

 

[Maquis]

If your user is running the query directly (clicking on the query in the database window) then there really isn't anything you can do about the results.

However, a better way would be to set up a form and have the user click a button on the form to run the query. You could then do a preliminary DCount function on the query and check for records. If the Dcount returns zero records then don't run the query. Instead pop-up a msgbox telling the user no records were found.

If Dcount("IDfield","queryname&quot = 0 then
msgbox "no records"
else
docmd.openquery("queryname&quot
end if Maq
<insert witty signature here>

 

[vistor]

I've also been looking for this! Maq, where would you put the above function, in the onclick event procedure of the button?

 

[Maquis]

Yep! Maq
<insert witty signature here>