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