467,921 Members | 1,336 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,921 developers. It's quick & easy.

Multiple Parameter Query

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
  • viewed: 1595
1 Reply
Expert Mod 16PB
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.

Similar topics

9 posts views Thread by Ed_No_Spam_Please_Weber | last post: by
1 post views Thread by Nicolae Fieraru | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.