Parameter Query Based on Form Input within a Union Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use criteria in the individual parts of the union query referencing the form
text box like this ---
[Forms]![YourFormName]![TextBoxName]
 
That makes sense. Thanks for your assistance. I needed a night to sleep on
it.

KARL DEWEY said:
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
 
Back
Top