<

Watch MS Access – Cascading Combos

Posted on
8,164 Points
1,864 Views
3 Endorsements
Last Modified:
Published
Experience Level: Beginner
4:06
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
Subforms can still help us achieve what we want to achieve as long as we understand how to use the MS Access tools.
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month