Hi,

Thank you for replying....Yes I can open it normally.

alansidma....I don't really want the query referenced with the open report line because I am just using the query to find out how many records there. The query is more a Count than anything as It counts how many records there are and If the count returns more than 0 then I want to open the report and if it returns 0 then show a message saying there are no records to run the report.