Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a parameter query that ask the user to input their request. It puts
the answer on a form so they can check the data and make any changes that are
necessary. After checking the info I want them to print this info on our
letterhead paper. I designed a report but the problem is that the report ask
the question the form asked. How do I by-pass that. After the information
is checked by the user I want them to press the print button and it go right
to the printer
 
It sounds as if the parameter query pops up is own little InputBox for
the user to input the parameter value. Instead, put a textbox on a form
for the user to enter the value before the query is run, and change the
parameter in the query to something like this:

[Forms]![NameOfForm]![NameOfTextbox]

That way, both times the query is run it will pick up the parameter
value from the form.
 
Back
Top