Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ComboBox Selection as Criteria for another ComboBox....
Message
General information
Forum:
Visual Basic
Category:
VBA
Title:
Re: ComboBox Selection as Criteria for another ComboBox....
Miscellaneous
Thread ID:
00505347
Message ID:
00505406
Views:
24
<<<
Thanks for replying, Eric. I just got it to work though (after hours of trying)
I left the variable names in the RowSource property. I'll look into refreshing, though.

I changed the Form Declarations to...
public vice dim

I left the click events alone...

in the comboBox rowsource(s)...
combobox1>>> left the same

combobox2>>> SELECT DISTINCTROW TABLE2.[FIELDc] FROM TABLE2 WHERE (((TABLE2.FIELDB)=[strF1]));

combobox3>>> SELECT DISTINCTrow TABLE3.[FIELDF] FROM TABLE3 WHERE (((TABLE3.FIELDD)=[strF1]) AND ((TABLE3.FIELDE)=[strF2]));

listbox1>>> SELECT DISTINCTROW TABLE4.[FIELDJ] FROM TABLE4 WHERE (((TABLE4.FIELDG)=[M_DESIG]) AND ((TABLE4.FIELDH)=[M_COMP]) AND ((TABLE4.FIELDI)=[M_LOC]));
Previous
Reply
Map
View

Click here to load this message in the networking platform