Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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
0
OnsiteSupport
Asked:
OnsiteSupport
  • 5
  • 2
  • 2
2 Solutions
 
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 5
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now