I have a report with two subreports on it; there is no record source on the main report. The criteria for the report comes from a form where the user selects the report type, the start date and end date. Then they click a command button that opens the report in preview for review prior to printing. It then clears out the data the user put on the criteria form to get it ready for the next use. The user then prints the report and this is where my problem comes in. When they print, the subreports get refreshed and now that the user input data has been cleared off the form the report comes out printed without any records shown even though they were there on the preview. It worked for a while then suddenly quit working a few weeks ago. It happens in both 2007 and 2003 and I can make it work if I don't clear the data from the input form after the report is opened. Does anyone know what could cause this?
I could leave it so the data on the input form is not cleared and put in a reset button to clear it after the report is closed or have it cleared after the report is closed. I don't really want to do it that way though because I would need to do the same for the other reports and they a working fine the way it is now; this is the only one I am having problems with.
I could leave it so the data on the input form is not cleared and put in a reset button to clear it after the report is closed or have it cleared after the report is closed. I don't really want to do it that way though because I would need to do the same for the other reports and they a working fine the way it is now; this is the only one I am having problems with.
Last edited:
