1
I have a query that compares two different tables, I have a button on a form that will open the query but I only want the query if it has results. I don't want it to open if the results are null. just have a message box pop up stating there are is no data.
I am thinking: if qry1=null then msgbx "no results" else docmd.openquery "qry1"
