storing a variable and filtering a report from a closed form
Posted on 2011-10-27
I have a Access 2010 DB based on a MS Sales Pipeline template. The print button on the form is set to check the form for dirty, save it, close it, and open a report based on the [ID] which was set prior to the form closing.
What I can't understand is why MS coded it this way as I can't see how the variable for the filter gets to the report if the form is closed. I took out the close comman and now the filter is set correctly, however as the forms are pop up, the reports are behind the form.
Can a filter criteria be passed to a report if the form is closed before the report opens?
If the form is Pop Up, can the form be made to fall back when the report is run?
In general, what is the best way to handle reports arising from reports and how to handle the windows. I didn't see a window mode...only pop up.