Newbe Question - Single and all selection

[melrios98]

QUERY
EquipmentID --- MoldID --- Task
1 4 Clean
4 3 Change
5 2 Out

I need to filter the equipments, sometime 1 of them and sometime all.

I have a table with a combo box that list all my equipments and this combo is the criteria on the EquipmentID field of the QUERY.

My problem is: I can't select all the equipments with the combo box

How i can do that ???

Thanks

 

[Zigzag]

You could try putting a "*" into the combo box or put

like ("*" & [yourcriteria] & "*") into your query.

Garry

 

[melrios98]

Thank for your response.

I'm using a query with the combo box of the equipments. I can't write any other than equipment on that list.

 

[Zigzag]

In that case you need to use

like ("*" & [Forms]![Formname]![Comboboxname])& "*")

In the criteria of your query.

If you leave the combo box empty the result we be all of your records.

Garry