G
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.
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.