Test if query returns any records

[Jon]

Hi all

I need to check if a saved query returns any records before opening a form
that uses it as a record source. I realise this I could use DCount like
this:

If DCount("*","QueryName") > 0 Then

but is this the most *efficient* way if the query returns thousands of
records ?

Many thanks

Jon

 

[Allen Browne]

Do you have a field that will always contain a value, such as a primary key
field?

If so you could use:
If Not IsNull(DLookup("ID", "QueryName")) Then
since the field will only be Null if there is not at least one record.

 

[Jon]

Thanks Allen

Probably the fastest reply I've ever had to a posting !

Yes, my query includes a primary key field so your suggestion worked right
off.

Thanks again

Jon