Parameter Query Complexity Question

[Paul7905]

I have a form on which contains 3 combo boxes, 3 list boxes and 2 option groups.

each of the controls are tied to product information or specific attributes of the product we sell.

Presently, i have this form working so that each control is capable of establishing the critera necessary to run a query which returns the item(s) which correlate to the SINGLE criteria selected by the user in one of these controls.

now i want to enhance the process so that the user can select multiple criteria.

The number of parameter combinations that the user will be able to select are enormous and i don't want to create a parameter query for every single parameter combination possibility and so am looking for some sort of technique to handle this, perhaps in VB code? (i am able to ascertain what selections have been made in code but don't know how to use this information to construct a query)

Question, is is possible to create a parameter query containing a parameter for every field that could be selected by the user and then, somehow, when i determine which parameters were actually selected, somehow "disable" the ones that were not and only pass the query the parameters that were ?

any help very much appreciated

Paul
PS, thanks so much to everyone on the forums that have given me so much wonderful assistance on this project.

 

[lreth]

Hi Paul,

I was wondering. Do you know how to create a parameter query which will allow the user to select what they want to query?

For instance, I am creating a product/supplier database. I want the query to come up and give a user the option of searching by a product number or by supplier name or by product name. After they select what they want to search, I want them to type in their search name. Is this possible.

Thanks in advance

L