I've got a web form that I need to make the selection criteria combo boxes dynamic.



There are 4 combo boxes and they all need to dynamic.

--- ANALOGY ---

So, if cboMonth is set to August, then all of the other combo boxes have to have Month = August as the Where Clause.

Then, if cboYear is set to 2007, then all of the other combo boxes have to have Month = August and Year = 2007 as the Where Clause.



The exact same where clause will apply to all 4 combo boxes.



--- ACTUAL SCOPE ---

The exact details are detailed in the attached word document.



Note - database and SQL statements are all provided. The aspx web form is provided with the combo boxes in place and the proper SQL statement (less the WHERE claue) included. I just need someone to be able to change the SQL statement feeding all four combo boxes every time one of the combo boxes is change.



I'm thinking if you can

1- create a function to create a where clause based upon each of the values that is not null

2 - set the results of that function to a variable-WHERE (this will be blank initially).

3 - include variable-WHERE in all 4 of the combo box's select statements.



Note - that I do not know HOW to do this - so it may not be this simple. That's why I want to hire YOU