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

ACCESS2k: requery second combo box to show a new value list

P: n/a
Hey, I was reading the google groups for info on this but the
explanation left out exactly how to do the query..

Lets say I have table1 with 2 combo boxes
combo1 has a value list of: "new", "old", "documentation"

- if I select "new", Id like combo2 to requery with the options
"hardware", "software"
- if I select "old", Id like combo2 to requery with options
"documentation","alien"

... I read that I should put a requery after combo1:
Private Sub combo1_AfterUpdate()
Me!combo2.Requery
End Sub
But.. how do I do this query which bases combo2 on combo1. Is it an
actual query or do I have to write some sort of code or something..

Thank you very much for your alien help.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.