Access 2003: Combo box based on results from ComboBox

I have a combobox containing a query criteria referring to the results of another combo box.

ie.,

cboMonth: Choose the Month
cboEvent:  Choose the Event based on cboMonth

What do I need to do to update the cboEvent contents if you change cboMonth?
trying requery isn't helping me unless I'm placing it in the wrong event.

Thanks
OnsiteSupportAsked:
Who is Participating?
 
Dale FyeCommented:
In the AfterUpdate event of cboMonth

Private Sub cboMonth_AfterUpdate

    me.cboEvent.Requery

End sub
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:


Private Sub cboMonth_AfterUpdate()
   Me.cboEvent.Requery
End Sub

0
 
OnsiteSupportAuthor Commented:
What are you guys in competition? LOL

Thanks again!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Dale FyeCommented:
I think I deserve all the points!  ;-)
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Mine is in BOLD to make it clearer !!!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Answers were post literally microseconds apart ... look at the ID's

36498467
36498470
0
 
OnsiteSupportAuthor Commented:
MX should get the points because his ID is longer  AND his response was more sarcastic.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Now you're talkin' .... lol
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"What are you guys in competition? LOL"
Man, it's a war zone out there Today!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.