Link to home
Start Free TrialLog in
Avatar of ExpExchHelp
ExpExchHelpFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Bitsqueezer
Bitsqueezer
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ExpExchHelp

ASKER

Absolutely perfect solution!!   Thousand thanks, Christian.  :)

EEH