Do not show an empty table

[margaret]

I'm going to use an unmatched query in a macro and if the two tables match, I
don't want an empty table to open. How would I "program" the unmatched query
so that it only opens if there are records?

 

[Ofer Cohen]

Use code for that, create a function in a module

Function NewFunctionName()

If Dcount("*","QueryName") > 0 Then
docmd.OpenQuery "QueryName"
End If

End Function
=====================
If you still want to use a macro, create one that calls the above function.

 

[margaret]

Thanks, I got that to work

Use code for that, create a function in a module

Function NewFunctionName()

If Dcount("*","QueryName") > 0 Then
docmd.OpenQuery "QueryName"
End If

End Function
=====================
If you still want to use a macro, create one that calls the above function.