Combo Box/Query Question

[Hank Stalica]

I currently have a query linked to a combo box on a form. The query
displays results based on the combo box query.

My problem is that the query will only show results if something is
selected from the combo box list, ChoiceA, ChoiceB, ChoiceC.

How can I add a value to the combo box that will show me ChoiceA, B, and C?

In other words, how can I query the entire table using the combo box?
Sort of like a "show all" option?

(Hope that wasn't too confusing)

 

[Douglas J. Steele]

You're probably better off using a list box than a combo box (list boxes
allow multi-select)

You can then use the code in http://www.mvps.org/access/forms/frm0007.htm or
http://www.mvps.org/access/reports/rpt0005.htm at "The Access Web" to limit
your query appropriately.