One prompt for Four Queries

I have four queries that are used as subreports in a summary report.

All four queries use the same prompt (for the same field): [Enter Patient
Contact ID]

How do I get only one prompt so that the keyed in patient contact id is used
for all four queries?

=?Utf-8?B?V2VuZGVsaW4=?= wrote:


I have four queries that are used as subreports in a summary report.

All four queries use the same prompt (for the same field): [Enter Patient
Contact ID]

How do I get only one prompt so that the keyed in patient contact id is used
for all four queries?

Make a form with a field or combobox to enter the ContactID.
Refer to the field in the criteria section of the queries like this:
=forms!FormName!FieldName

Add a button to the form to open the report.

--
Groeten,

Peter
http://access.xps350.com
http://foto.xps350.com

Enter it in a text box in a form.

In the criteria of the queries put something like this:

[Forms]![FormName]![TextBoxName]

You could put a command button on the form to run a macro that runs the
queries.

The form must stay open for this to work; however, it can be minimized or
invisible.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Wendelin" wrote:

I have four queries that are used as subreports in a summary report.

All four queries use the same prompt (for the same field): [Enter Patient
Contact ID]

How do I get only one prompt so that the keyed in patient contact id is used
for all four queries?

One way is to have the queries reference a field(s) on a form. The visible
property of this field may be either true or false pending if you want it
displayed or not.

You can also do this if your query/report contains multiple criteria
elements, for example: FiscalYear, Division, Dept, etc.

In the criteria it would look something like
[forms]![frm_ReportMenu]![FiscalYear]

Give it a try,

SteveD



"Wendelin" wrote:

I have four queries that are used as subreports in a summary report.

All four queries use the same prompt (for the same field): [Enter Patient
Contact ID]

How do I get only one prompt so that the keyed in patient contact id is used
for all four queries?