<

MS Access – Cascading Combos

Posted on
8,168 Points
1,868 Views
3 Endorsements
Last Modified:
Published
Experience Level: Beginner
4:04
Jim Dettman (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
0 Comments
Listing and selecting time zones in Microsoft Access and Excel is not straight forward. In the previous article was shown how to retrieve the time zones of Windows. Here will be demonstrated how to create tables to store these and how to display and…
This is a rather simple but effective way of searching while typing on a Microsoft Access Combobox.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month