Multiple Parameter Query

Mpho Pole

Hi everyone.I'm a newly minted member, and I'm glad to be here. Now that the pleasanteries are out of the way, my problem is as follows:

I have an SQL query which receives multiple parameters from a form depending on the users' choice. Most of the parameters are in drop down combos on the said form and I would like my SQL statement to return results according to the values of the drop downs regardless of the number of drop downs.

The drop downs on the form are deactivated when the form loads and the activation depends on whether the check boxes alongside the drop downs are ticked.

There are eight drop in total and I would like to have results based on any number of combinations from the users' choice

Nov 28 '06 #1

NeoPa

You will need some VBA code then.
It will need to check the status of each ComboBox in turn and, if it is enabled, add the relevant check to a string that you need to build up to provide the SQL.

Nov 28 '06 #2