By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

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

P: n/a

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!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.