Unanswered: Print Preview Freezeing on load with filter
Morning, I have run into a snag on all of my reports. I've scoured the internet, but there is very little on this issue and no resolutions that I have found. I am attempting to start locking down my database, though I have no decided how far. I have been testing a Print Preview button on my reports.
The button itself works fine, until the report is filtered. Once the filter is activate on a report and I use my print preview button, the report goes into print preview, however I am unable to click anything on access. Anything = Anything, no tool bars, buttons, scroll bars or anything else. However if i tab out of access and tab back into it, it works perfectly fine.
If I toggle the filter off before I click on my print preview button it works.
That is my only line of code and its on the Click Event of the button.
I appreciate any ideas and your time in reading over this. Thanks!
you are correct. the docmd. runcommand accmdprintpreview is a button on the report. I apologize for not being specific enough in my first post. However, since it is a button on the report, the report has already been generated. The paramater passing has already been completed.
I have a report selecter/filter form. If they only want the report to run from dates a to c then they'll put it on the form, select the report they want to run and then hit a button to create the report. This is where the paramater passing is done.
At this point the report comes up. I have created 3 buttons on the report which is only see on report view. A Print Preview button, a print button and a close button.
If i change the view by right clicking on the report it will change to print preview with no problems. However, using my button to change the report presents the problem explained earlier.
Incase the question comes up. The basic way I filter is something like this: