If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
One prompt for 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 |
#3
|
|||
|
|||
One prompt for Four Queries
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? |
#4
|
|||
|
|||
One prompt for 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? |
Thread Tools | |
Display Modes | |
|
|