How to provide a paramter for a report

B

Bob Richardson

A Query is used to determine the records shown in a report. At the moment,
when a user clicks a button to see this report, he gets the "Enter Parameter
Value" dialog box. Since this parameter info is always on the form (where
the print button is) I want eliminate the need for typing in this parameter.
How can I do that?
 
S

Steve Schapel

Bob,

In the query, in the place of the parameter prompt, you can enter a
Criteria that refers directly to the value of the control on the form,
using syntax such as...
[Forms]![NameOfForm]![NameOfControl]
 
R

RoyVidar

Bob Richardson wrote in message said:
A Query is used to determine the records shown in a report. At the moment,
when a user clicks a button to see this report, he gets the "Enter Parameter
Value" dialog box. Since this parameter info is always on the form (where the
print button is) I want eliminate the need for typing in this parameter. How
can I do that?
Click to expand...

In the query, where you know have [Enter blah...], replace that with
something
like this

forms!frmNameOfYourForm!txtNameOfYourControl
 
Top