Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2003: Combo box based on results from ComboBox

Posted on 2011-09-07
9
Medium Priority
?
263 Views
Last Modified: 2012-05-12
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
Comment
Question by:OnsiteSupport
  • 5
  • 2
  • 2
9 Comments
 
LVL 49

Accepted Solution

by:
Dale Fye earned 1000 total points
ID: 36498467
In the AfterUpdate event of cboMonth

Private Sub cboMonth_AfterUpdate

    me.cboEvent.Requery

End sub
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 36498470


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

0
 

Author Comment

by:OnsiteSupport
ID: 36498535
What are you guys in competition? LOL

Thanks again!
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 49

Expert Comment

by:Dale Fye
ID: 36498544
I think I deserve all the points!  ;-)
0
 
LVL 75
ID: 36498564
Mine is in BOLD to make it clearer !!!
0
 
LVL 75
ID: 36498578
Answers were post literally microseconds apart ... look at the ID's

36498467
36498470
0
 

Author Closing Comment

by:OnsiteSupport
ID: 36498591
MX should get the points because his ID is longer  AND his response was more sarcastic.
0
 
LVL 75
ID: 36498614
Now you're talkin' .... lol
0
 
LVL 75
ID: 36499103
"What are you guys in competition? LOL"
Man, it's a war zone out there Today!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question