How to provide a paramter for a report

  • Thread starter Thread starter Bob Richardson
  • Start date Start date
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?
 
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]
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing date parameters on a report 3
report after parameter form 3
Printing Report for one a single record - Several problems 5
pass paramter to crosstab query report 1
how to pass a parameter to a query base of a query that is the base of a report 0
Report Query Parameters 2
Report with Subreports ----M----- 3
Problems generating reports from a modal dialog 3

Back
Top