Print Preview prints form not report

[Guest]

How can I get the reports to open in preview and be the view that the Office
button will print?

I have a form that allows the users to select certain filters then print a
variety of reports. I have one button to open report in report view and one
that opens it in print preview. all that works fine.
My problem is when I hit the print preview macro button it filters and opens
the report correctly, but if I go to the top left "Office" button go down to
print and select print or print preview and it prints the form, not the
report. I've tried closing the form and it still prints the form.
What I've noticed is that going to the office button to print prints
whatever is currently selected in the navigation frame even if that isn't the
active window.

my macro that opens the form is the OpenForm macro and I've selected it to
open in print preview. If I change this to open in "print", it prints the
right report, but I really need the user to see the preview first and use the
print commands so they can make sure it's what they want and make any print
adjustments.

 

[Allen Browne]

Simplest solution might be to add a button to your form.

Details in:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

 

[Guest]

Yeah, I have as a back up two buttons, a print preview and print direct.
One thing I found that did solve my problem was to turn the pop up off on
all the reports. This will force the report to be the focus of the print
preview. However it produces a new problem as the report print preview can
get hidden under other open windows and the user may not see it or has to
move a bunch of stuff to get to it. My work around for that was to minimize
the report calling form when print preview button is clicked. Not ideal, but
workable.

My reports are all summarys of whole record sets though and the form that
calls the report is not the form for the records in the report, it's just a
form of buttons and filter criteria. Long way to say printing a single
record isn't an issue in my case.

thanks for the note.