MacDaddy
03-02-2010, 07:16 AM
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
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