Selecting two items for query from combo box

[BatmanMR287]

I have a combo box that has three items in it. Name, ID_Num, Date


I need to use ID_Num and Date to filter the results of query. I can use one or the other but not both. I have tried ListIndex but apperently am writing it wrong in the expression builder. [Forms]![TableName]![Combo0].
[ListIndex]????????????
I have tried =0, =1, =2 after the
[ListIndex] but it doesn't work.
How do I use two items from combobox in a query?

[June7]

A query cannot reference columns of combobox as parameters. This won't work in dynamic parameterized query.

Base a form or report on the query and apply filter criteria to form or report. Build the filter criteria string with VBA. http://www.allenbrowne.com/ser-62.html

[BatmanMR287]

Gottcha, I made two combo boxes and tied them together and set refresh off of the first one. Works fine.