Parameter Query Based on Form Input within a Union Query

[jbrickey]

I have created a union query, but want to base the results on what is entered
on a form. How would I go about doing that?

Thanks.

Jana

 

[KARL DEWEY]

Use criteria in the individual parts of the union query referencing the form
text box like this ---
[Forms]![YourFormName]![TextBoxName]

 

[jbrickey]

That makes sense. Thanks for your assistance. I needed a night to sleep on
it.

Use criteria in the individual parts of the union query referencing the form
text box like this ---
[Forms]![YourFormName]![TextBoxName]
--
KARL DEWEY
Build a little - Test a little

I have created a union query, but want to base the results on what is entered
on a form. How would I go about doing that?

Thanks.

Jana