G
Ghagg
Thank you Wayne-I-M for responding
FYI: I'm using Access 2007, and the combo boxes are unbound. The fields i'm
using are not primary fields, and i use the Distinct key word for populating
the combo boxes, which worked in the cascading listbox example.
OK, Consider this, i have a table with over 100K records, about 50 fields.
The class field has 210 items that repeat through out the records in this
table. I want to chose this class field as an example, then select one item
in the drop-down combo box, and filter all records based on the combo box
selection. I also have 3 cascading combo boxes.
I hope the combo box works like the list box, As i previously mentioned, i
have been able to get the 3 cascading list boxes to work with 3 different
queries. The Second list box query selects from the first list box query...
I think the problem i'm having is passing the value from the combo box
selection to the query.
Thanks for your help
Best regards,
Glenn (ghagg)
FYI: I'm using Access 2007, and the combo boxes are unbound. The fields i'm
using are not primary fields, and i use the Distinct key word for populating
the combo boxes, which worked in the cascading listbox example.
OK, Consider this, i have a table with over 100K records, about 50 fields.
The class field has 210 items that repeat through out the records in this
table. I want to chose this class field as an example, then select one item
in the drop-down combo box, and filter all records based on the combo box
selection. I also have 3 cascading combo boxes.
I hope the combo box works like the list box, As i previously mentioned, i
have been able to get the 3 cascading list boxes to work with 3 different
queries. The Second list box query selects from the first list box query...
I think the problem i'm having is passing the value from the combo box
selection to the query.
Thanks for your help
Best regards,
Glenn (ghagg)