<

MS Access – Cascading Combos

Posted on
8,058 Points
1,759 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

The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Are you ready for a Linked Table Manager (LTM): - with a sizable form - which identifies which connections are valid and how many tables are associated with the connection - which doesn't ask you to select the BE multiple times when you've ident…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month