<

MS Access – Cascading Combos

Posted on
7,938 Points
1,638 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Suggested Courses
Course of the Month3 days, 9 hours left to enroll

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month