Solved

Access 2003: Combo box based on results from ComboBox

Posted on 2011-09-07
9
219 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 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

777 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