Query with Picklist Crieteria

[Eric]

I'm trying to figure out how to create a Pick List or Combo Box within a
Query. What I need is to pull serveral pieces of info from different tables,
all based on two values. The two values are found within one table -
Discription and Deleted Date.

I want the Discription field to be a Combo or Pick list that a user can
select one or more values from. However, if the deleted date is populated,
then I don't need the Value to appear.

Any suggestion on how I can write this query?

 

[KARL DEWEY]

Use an unbound form with two unbound combo boxes.

 

[Eric]

OK - thought of that - but - isn't there a way to not use a form?

 

[KARL DEWEY]

I never heard of a combo that was not on a form. Have you?