<<<
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]));
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement