<

MS Access – Cascading Combos

Posted on
8,109 Points
1,809 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
0 Comments

Featured Post

Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Copying and pasting of files will continue, at least for now. The front end MS Access 2016 and SQL Server 2016 back-end can be zipped together and emailed to clients like any other file without problems, I have thoroughly tested the detailed method …
A common question in the Access topic area is how to pass values between forms or reports.  These threads frequently evolve into a discussion on how to save values so they can be used throughout the application.  This article will discuss some of th…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month