Cascading Combo Box Question

[CO711]

Hi all,

Thanks for Taking the time to read this I have a problem that I have been struggiling with for a while now. I want two cascading combo boxes. The Second one Filtering off the First, then displaying the correspoinding information in a subform or whatever works best. I don't beleive the normalization of my data base is wrong, but it's just not connecting. This are the data bases I'm working with.

 

[KenHigg]

a. Welcome to the forum
b. If you take a few minutes to learn how to use the formatting capabilities of the forum engine you can post things like your table structure in a more readable manner. This will increase the likelihood (sp?) of someone taking a few minutes out of their busy schedule to try and help -

 

[CO711]

a. Welcome to the forum
b. If you take a few minutes to learn how to use the formatting capabilities of the forum engine you can post things like your table structure in a more readable manner. This will increase the likelihood (sp?) of someone taking a few minutes out of their busy schedule to try and help -

thanks! im headed there now!

 

[KenHigg]

tblProdGrp
ProdGrpId Product Group
1         A
2         B
3         C
4         D
5         E
6         F

t
blProdName
Prod ID Product Name ProdGrpId
201     10      TTI  1
202     155     IST  2
203     20      JJP  3
202     BOX     t    4
201     EWQ     232  5

I'm not sure how tblInfo breaks down

 

[CO711]

here we go

I apologize for posting information so sloppy. I have attached a sample data base in this word document. I will post my form once I figure it out, but again thanks, and let me know if there is any confusion about what I am trying to achieve.

Thanks

 

[KenHigg]

Combo box one is simple. Combo two's rowsource is a query that uses combo one as a criteria. The the form uses combo two's value as a criteria. The trick is to requery two when the value in one changes and to requery the form when the value in two changes.

There should be some pretty good samples in the forum if you do a search on cascading combo boxes.

 

[CO711]

I'm somewhat aware of this and have been struggiling with the requery, but will continue to research it. Do I need to use the Link Child Fields or Link Master Fields to get the sub form responding to the combo boxes?

 

[KenHigg]

No. In fact that has mysteriously set itself up on some of my forms/subforms by itself and caused me headaches.

 

[KenHigg]

I'm going to check out for the day - Hope you get this working

 

[CO711]

I've been strugeling with this all day and last week, any ideas or samples forms anyone could create would be greatly apprecitated.

 

[pbaldy]

I have a sample here:

http://www.baldyweb.com/CascadingCombo.htm

 

[tl mike]

I have been having problems with a cascade combo using all the codes shown but when I went and did a cascade using the 1st combo as the criteria for the secound in a qry and on the after update event for the 1st combo added:

Me.Combo2 = Null
Me.Combo2.Requery

It seems to work fine even with my proper save setup that I have on the form.

Is there anything wrong with going this route??