<

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
While working on a calendar and appointment scheduling application, I found I needed to synchronize multiple sub-forms, displayed side-by-side, so users would be able to see the schedules of multiple care providers and identify gaps in their schedul…
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Storing hashed or encrypted data.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month