<

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

x

MS Access – Cascading Combos

Posted on
7,708 Points
1,408 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
4:06
Jim Dettman (Microsoft MVP/ EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.

Video Steps

1. Base the dependent combo on a query for its row source

2. Add a reference to the first combo on the form as criteria in the query

3. In the after update event of the first combo, add a requery of the dependent combo

3
Comment
0 Comments

Featured Post

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.

Join & Write a Comment

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month