1. Bug Fix - Product Groups (7:34)
Ignore Product Groups
Inventory Calculations

2. Dynamic Customer Search Form 1 (42:18)
Dynamic SQL
Build the List Box
Add Sorting Labels
Sort NULL Values To Bottom of List
IS NOT NULL Sort
Colorize Ascending Descending

3. Dynamic Customer Search Form 2 (20:50)
Field Filter Boxes
Clear Filter Button
Build Dynamic Where Condition

4. Recordset Based Search Form 1 (26:32)
Create SearchT
Delete Filter Boxes
Delete AND / OR Combo
Create RS Loop For Where Condition
TableDefs, Fields, Field Type
Process Numeric, Text, Date, Different
Make Search Subform

5. Recordset Based Search Form 2 (37:03)
For Each Field in TableDef Fields
Fill Combo Box with Field Names
Add Criteria to SearchT
Delete Criteria Button
Update Records on Any Change