Reopen Form after No data is found for report

[ssalem]

Not sure how to handle this and just need to be pointed in the right direction. Can't seem to find what I am looking for by doing research. My task I think should be rather simple and something I am sure someone has incountered before but can't seem to find it. I have a report whose parameters are controlled by a form. Right now I have the report checking on the No Data event if no records are returned to show a message box and set Cancel = True so the report does not open. But on the On Close event of the report it closes the Form. I want the form to either remain open or reopen after no data is found. I have tried running a macro that reopens the report and is triggered in the no data event but of course it does not work because when the report closes it closes the form. But if it is a good report i need it to close the form when the report is closed. Do I need to instead of using the No Data Event be checking the Data Set in the Report Open event instead and then cancel opening the report and set my form to visible. I just need some direction and can figure out the commands.

Thanks in advance.

[June7]

Should be able to have conditional code in the Close event to not close the form if there is data. Try in the Close event:

If Me.HasData Then
DoCmd.CloseForm ...
End If

[ssalem]

Hi I figured it out. It was at all not what I thought though. Putting a conditional on the close of the form did not solve the problem. It still returned to the switchboard which closed everything. What I ended up doing is creating a Public variable as boolean in my standard module. I set it to False and only set it to True if the where no records in the dataset. I created a do until varialbe was false loop in the switchboard to re-open the report, thus reopening the form for the parameters. This way if a person kept putting invalid report parameters the program would return to the form giving them a chance to put valid parameters in. Only when they did put in valid parameters or hit the quit button would it exit the form. The whole trick was handling it at the switchboard level. I only figured this out by totally stepping through the whole vb I had written. Thought I would post this in case someone else needed quidance in handling this same problem.

[ssalem]

Just another quick note...on my Quit button command I had to set my Public variable to False to be able to quit.