Combo box / Query

[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)

 

[Wayne-I-M]

Hi

You should try to responpond to the same threat so that there is a contious
line of posts that people can read and see any problems/questions.

I still think the answer lays in simply creating a query then filtering it
on your combo selection - this can be the primary field or the distinct
text/number/forumla/etc

Can I suggest something

Make a copy of your database.

Open the form with the 3 combos on it
Delete the source from the 2nd 2 in the casscade
(if you need to) use the wizard to creat 2 more querrys (click the build
option on the property's data column). Which you are still in the design
view of the querry use the build option on the criteria row (point to the
previous combo in the casscade - to the bound column in the combo)

Your 3 combos will casscade as you need.