I'm (very) new to Access. I created a query which filters the results based on a value the user enters and then I created a report based on that query (so it looks nice to the user). I entered a few basic macros so that when the report is opened the primary form (which contains a command button to open the report) closes and then opens the report. Then, when you're done with the report and close it, I used a macro to open the previous form. This creates a "loop" so that users have either the primary form or a report open. When one opens the other closes and when the other closes the one opens. Fairly basic stuff.
Here's my problem: When I hit the "Cancel" button in the "Enter Parameter Value" box the report doesn't run and the primary form closes (because I used a macro to close it when the report is opened) leaving the user with a blank screen. I think that because the report didn't run there's a gap where the macros in the report can't execute, therefore, the primary form isn't opened per the report macro.
Ultimately, I need a solution (maybe some VBA) that opens the primary form when nothing else is open. Is that possible?
Best Regards,
Eddy Sincere