Combo Box that returns all values

[RonMcNatt]

I think my previous thread was misleading. I'm using a combo box to feed a criteria field in a query.

How do I get the combo box to send a value that gives me all the records in the table?

The current choices of "North", "South", "East" all return the records that correspond to the appropriate value. I want to give the user the option to return all the records.

Any thoughts would be appreciated.

Ron McNatt

 

[RonMcNatt]

Well After a couple more hours of digging, I found the answer. The solution was to combine the Like Function with the IIf function.

For my solution, I have ALL as one of the values in the combo box. Then in the criteria portion of the query I have this statement:

Like IIf([Forms]![Form1]![Combo0]="All","*",[Forms]![Form1]![Combo0])

This works like a charm. Thanks everyone for your time. This site ROCKS!!

Ron McNatt