Query criteria retrieved from a Form combobox?

[blacksaibot]

Right now on my form I have a comobox with 3 options.



The third option is an "all of the above" case.

The query takes the selection from the form combobox like so:

[forms]![formname]![comboboxname]

The problem is: I can't figure out how to tell it to take both option1 and option2 as the criteria when option3 is selected in the combobox.

My intial thought was to put an asterisk (*) because I remember back in my SQL days * meant "everything" but that won't work. any help? Thanks!



EDIT: Also, how can I do the same thing but with a listbox that has a multiselect??

[blacksaibot]

I got it........

In SQL view...

Where fieldname=([forms]![formname]![comboboxname]) or [forms]![formname]![comboboxname]="all of the above")


Anyone know how to solve the multiselect in combobox issue?
Something tells me VBA might be involved, not 100% sure how I'd pull it off without it. VBA is not my strong point. I guess looping through the items that are selected???