Up to 3 combo boxes as query criteria???

[andrewf10]

I have a combo box called 'Status' of which there are 6 values to choose from.

What I'm trying to do is have a report that will display results based on a query that takes the combo boxes value in as criteria. This is no problem for a single combo box. However, I want to be able to select up to 3 statuses. Can this be done?

Thanks in advance

 

[EMP]

In query Design View, put the citeria for the status field like this:

[forms]![formName]![combo1] Or [forms]![formName]![combo2] Or [forms]![formName]![combo3]

 

[andrewf10]

Works great, thanks a million!