Parameter query

[quijote]

I have a parameter query that feeds a form. I use 4 different fields that filter the records I want to show in the form. I am using a form (user will fill out criteria in form) to feed the criteria in the parameter query for the different fields used as filters using the format [forms]![Parameter].[text0]. One of the fields to fill out the criteria is a combo box, I want to know if there is a way to select all the choices from the combo box, right now I can only select one. Let me know if there is a way to do this. Thanks

 

[jfgambit]

Add the following to the criteria of the field that gets its info from the combobox:

iif(IsNull([Combobox]),[NameofField],[Combobox])

HTH

 

[quijote]

Thanks, works great