Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2003: Combo box based on results from ComboBox

Posted on 2011-09-07
9
Medium Priority
?
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
9 Comments
 
LVL 48

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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 48

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

704 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