Filter a Form on a Field in Subform
I am looking for a VBA code to filter a form based on a field in a subform.
The system in question is a (simple) CRM system.
The tables in question are:
CONTACTS (Customers/prospects).  
and CATEGORY  (customer category such as Prospect, Customer and 4 other fields)
The Contacts form draw its records from the CONTACTS table and
and the subform from the table CATEGORY.
The CATEGORY table fields: Category and Service are the fields I want to be able to filter on to focus on all the prospects that might be interested in a particular service.
Please let me know if you need additional information.