query with no results

[Jackske]

I have a form based on a query.
I want – before the form appears on the screen – to check if the query is empty or not.

Via which Event can I do this and what is the code.

Thanks,

Jackske/Belgium

 

[maxmangion]

try the following on the OnOpen of the Form

If DCount("*", "Queryname") = 0 Then
MsgBox "Empty box"
DoCmd.Close acForm, "formname"
End If

 

[maxmangion]

Also if you remove the msgbox, simply nothing happens !

 

[Jackske]

thanks but it did not work.
I had to create first a table and after this, to check if the table is empty.

Never less, thanks


Jackske/Belgium

 

[maxmangion]

i have tested it on a form based on a query myself and it worked fine for me! did you get any error message ?

 

[Rich]

Or
http://www.access-programmers.co.uk/forums/showthread.php?t=62548&highlight=recordsetclone