3rd and 4th combo boxes don't pull the correct data

[Stephanie Wright]

I'm having a probem with my 3rd and 4th boxes not showing the correct
data to pick. My database is normalized and I have Me! statements for
each combo box in the After Update but something is quirky about it.
Also I have a subform that is supposed to show the results and it does
for the first 2 but not for the 3rd and 4th. I'm not using the child
link method, it's in the code for that too. Any ideas what might be
wrong?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Larry Linson]

"Stephanie Wright" <cw*****@zbzoom.net> wrote in message
news:40*********************@news.frii.net...

I'm having a probem with my 3rd and 4th boxes not showing the correct
data to pick. My database is normalized and I have Me! statements for
each combo box in the After Update but something is quirky about it.
Also I have a subform that is supposed to show the results and it does
for the first 2 but not for the 3rd and 4th. I'm not using the child
link method, it's in the code for that too. Any ideas what might be
wrong?

The AfterUpdate event of each combo box should .Requery the next ComboBox in
the "hierarchy", and each should include the value of the previous Combo in
its RowSource as a criteria. As to the Subform, without seeing the code, we
couldn't guess what might be wrong with it (if anything). We'd also need to
know where that code is located. It would be interesting to understand why
you did not use LinkMasterFields and LinkChildFields (note that both are
plural, so can refer to more than one field or control on the main form, and
that's usually the easiest and most reliable way -- you will also need to
Requery the Subform Control after setting the last of the Combo Boxes).

Larry Linson
Microsoft Access MVP