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 FyeConnect With a Mentor Commented:
In the AfterUpdate event of cboMonth

Private Sub cboMonth_AfterUpdate

    me.cboEvent.Requery

End sub
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:


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

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

Thanks again!
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Dale FyeCommented:
I think I deserve all the points!  ;-)
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Mine is in BOLD to make it clearer !!!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
Now you're talkin' .... lol
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"What are you guys in competition? LOL"
Man, it's a war zone out there Today!
0
All Courses

From novice to tech pro — start learning today.