ExpExchHelp
asked on
Update SQL/VBA to accommodate cascading drop-down values in combo boxes
Experts:
I need some assistance with modifying my VBA/SQL for an Excel spreadsheet.
First things first... I do NOT want to use Excel's built-in "Auto Filters"... reason for such is not important in this thread though.
Instead, I would like to modify my VBA/SQL to utilize the principle of cascading drop-down menus for the combo boxes (Active X controls).
Current Process:
1. Select values from the drop-down boxes (travel category, state, or city).
2. Click on "Show Data" to display matching records (listed in tab "SourceData").
3. Right now, based on the source data, any non-existing record combination shows as "No matching records were found".
What I envision/would like to change in the VBA/SQL:
Instead of arbitrarily finding out that a record combination does not exist, I would like to apply the principle of "cascading drop-down" menus for showing/not showing available filter values. Please see some additional explanations (i.e., screenshots) on the tab "Source Data with explanations".
How do I modify the VBA/SQL in order to not incur "no matching records found"? I appreciate any assistance!
Thank you,
EEH
Quick-Filter.xlsm
I need some assistance with modifying my VBA/SQL for an Excel spreadsheet.
First things first... I do NOT want to use Excel's built-in "Auto Filters"... reason for such is not important in this thread though.
Instead, I would like to modify my VBA/SQL to utilize the principle of cascading drop-down menus for the combo boxes (Active X controls).
Current Process:
1. Select values from the drop-down boxes (travel category, state, or city).
2. Click on "Show Data" to display matching records (listed in tab "SourceData").
3. Right now, based on the source data, any non-existing record combination shows as "No matching records were found".
What I envision/would like to change in the VBA/SQL:
Instead of arbitrarily finding out that a record combination does not exist, I would like to apply the principle of "cascading drop-down" menus for showing/not showing available filter values. Please see some additional explanations (i.e., screenshots) on the tab "Source Data with explanations".
How do I modify the VBA/SQL in order to not incur "no matching records found"? I appreciate any assistance!
Thank you,
EEH
Quick-Filter.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
EEH