By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,396 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,396 IT Pros & Developers. It's quick & easy.

Multiple Parameter Query

P: 3
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
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,661
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

Post your reply

Sign in to post your reply or Sign up for a free account.