Reports

  • Thread starter open a adobe file from a command button
  • Start date
O

open a adobe file from a command button

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
 
J

John Nurick

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