Hi

Thank you for all your help however I have solved the problem. The report I was trying to open had a filter on the data, so I took that out and in the VBA code I add a where clause to the Open report line and NOW it not only opens without a debuggig it gets the correct reuslts and prints the report.

Thank you for anyone's help i greatly appreciate all of it!!!!