1. Bound Multi-Select Listbox 1 (29:28)
Recordset Types
dbOpenTable, dbOpenDynamic
dbOpenDynaset, dbOpenSnapshot
dbOpenForwardOnly
Multi-Select Option Listbox
Product Interest Junction Table
Subform to Select Products
Replace with Multi-Select Listbox
Load Values OnCurrent
2. Bound Multi-Select Listbox 2 (11:15)
Save on AfterUpdate of Listbox
Save on AfterUpdate of Form Once
Me.Dirty
3. Nested Recordsets (13:41)
Customers w Contacts
Multiple Recordset While Loops
4. Chef's Kitchen Helper 1 (18:15)
Recipes, Ingredients, Inventory
Products On Hand
What Can I Make?
5. Chef's Kitchen Helper 2 (17:15)
Quantity on Hand
Quantity Required
Calculate with Queries
6. Chef's Kitchen Helper 3 (24:54)
Use Nested Recordsets
Fill Listbox
7. Chef's Kitchen Helper 4 (22:22)
Select Dish to Make
Remove Ingredients From Inventory