Good afternoon,
I'm not sure if this needs to be in the Excel or SQL section so apologies if I've stuck it in the wrong place:
I have an Excel userform with three combo boxes with choices populated from a SQL Server database for validation purposes.
What I would like to do is make the second and third combo box dependent on the choices selected from the previous combo box selection.
I have done a good Google search for cascading combo boxes but I can't find anything on how to accomplish this if using a SQL Server database as the source.
Somehow the choice of the second and third boxes needs to be filtered in the where clause of the SQL string, but I don't know how to pass this value in the vba code.
If anyone can point me in the right sort of direction I'd be most grateful.
Thanks,
Paul