many queries with same parameters

[kristy]

I am running several queries in a row that ask for the
same parameters (begin dates, end dates). They are
running within a macro. I have to rekey the paramaters
every time a new query starts. Is there a way to ask for
this information one time and then use the results in
several queries without having to reenter?

 

[Ken Snell]

Create a form that has textboxes on it for the values you want to use. Then
have the queries read the textboxes instead of asking for parameters:

Between [Forms]![Formname]![txtBoxName1] And
[Forms]![Formname]![txtBoxName2]

for example.

The form will need to be open while all the queries run.

 

[Kristy]

THANK YOU!! That did the trick!

-----Original Message-----
Create a form that has textboxes on it for the values you want to use. Then
have the queries read the textboxes instead of asking for parameters:

Between [Forms]![Formname]![txtBoxName1] And
[Forms]![Formname]![txtBoxName2]

for example.

The form will need to be open while all the queries run.

--
Ken Snell
<MS ACCESS MVP>

I am running several queries in a row that ask for the
same parameters (begin dates, end dates). They are
running within a macro. I have to rekey the paramaters
every time a new query starts. Is there a way to ask for
this information one time and then use the results in
several queries without having to reenter?

.

 

[Ken Snell]

You're welcome.

THANK YOU!! That did the trick!

-----Original Message-----
Create a form that has textboxes on it for the values you want to use. Then
have the queries read the textboxes instead of asking for parameters:

Between [Forms]![Formname]![txtBoxName1] And
[Forms]![Formname]![txtBoxName2]

for example.

The form will need to be open while all the queries run.

--
Ken Snell
<MS ACCESS MVP>

I am running several queries in a row that ask for the
same parameters (begin dates, end dates). They are
running within a macro. I have to rekey the paramaters
every time a new query starts. Is there a way to ask for
this information one time and then use the results in
several queries without having to reenter?

.