avoiding multiple repetitive input

[russanalyst]

Hi.

I have numerous queries each based on a different table. With the same parameter, although each table has difefernt fields.
Currently the user has to enter the parameter multiple times.
I do NOT need the user to modify, add, or change adta. Simply to see existing data.

How? Please be specific. Thanks.

Russ

 

[PHV]

Use a Form for the parameter.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[straybullet]

Create a form with a textbox for entering the parameter. Have the criteria of the queries refer to the control on the form:
Forms!frmFormName.txtControlName

Then a button can be added to the form to run the queries. So long as the form remains open, the queries can find the input they need.

Let them hate - so long as they fear... Lucius Accius

 

[russanalyst]

1st, thanks for responding, both of you.

It is probably me bueing 'burned' or just 'dense'.

I am missing how to set up the form.

Can I upload one of the queries so you can see what I have?

Russ

 

[lespaul]

In the main Access database "box" it lists on the left side:
Tables
Queries
Forms
Reports
Pages
Macros
Modules

and when you select an option (Tables, Queries, Forms, Reports, Pages) you get the following additional options:
Create ______ in Design View
Create ______ by using Wizard

Follow the wizard.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins