Gail said:
I have a report that prompts for criteria. The report is
connected to a button on the "Switchboard". When I click
on the button, Access prompts for the criteria, then the
report goes to print preview. This is exactly what I
want. However, if I try to print the report to a printer
from the "Print Preview" mode, Access prompts me again for
the same criteria before it prints on the printer. Is
there some way to have it only prompt one time??
Hi Gail,
I'm basically a novice here but here's what I would do (for what it's
worth). I warn you it's probably not the most elegant solution to your
problem but it's certainly simple.
I would guess that at the moment when you run the report it's part of the
query behind the report that is prompting for your criteria?
Why not have it so that when you click the button on the switchboard it
opens a small form.
The user then puts the required data into this form and clicks a button
(let's call it OK).
Set the button on this form up so that instead of closing the form it hides
the form (set the IsVisible property of the form to No).
You can now tell your query to take it's criteria from that form.
As the form is open (it's still there, you just can't see it), when you go
to print the report the criteria should still be available.
You could then either leave the form open (but hidden) until the next time
it is needed or close it after the report is run.
Hopefully the above makes sense, if not post back and I'll try to clarify
it.
Like I say, I'm a complete novice (more or less) so it's probably worth
hanging on for a little while and seeing if you get a more elegant solution
than this one (or in case someone posts after my post to tell me not to be
such a pudding! ;-) ).
Good luck anyway,
Raist.
