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.