01. SQL Search Boxes (35:50)
Create Unbound Search Text Boxes
SQL Statement to Replace RecordSource
Build SQL Statement in a Text Box
Separate WHERE Clause Box
Multiple Conditions

02. Data Macros (17:40)
BeforeChange
If NumEmployees < 0
SetField
RaiseError
ProductT Add UnitCost, Markup
Auto Calculate UnitPrice
If [IsInsert] For Adding Records
After Update
Create a Log Table
="Updated " & [CustomerT].[CustomerID]
Macro Shortcut on Desktop