Excuse a non-programmer daring to enter but I'm trying to filter a set of records using a combo box. Followng an article in Inside Access (vol3, 7, page 5) I've got the code below as the after update event for the combo box
DoCmd ApplyFilter , "[Supplier] = Forms!SupplierItems!Search"
where Supplier is the field I want to filter on the form 'SupplierItems' and Search is the name of the combo box.
When I complie this code I get an error 'Variable not defined' with 'ShowAllRecords' highlighted. I guess my model was written in Access 2 days. is this my problem? Does anyone have the fix please?