Filter combo box records

[tinab]

I have a subform to track costs of a job. On the form I have a
product category field (combo box) with records from the Product
category table. The next field is a Product ID field (combo box) with
records from Products table. I would like to select the product
category and then all the records for the Products combo box would be
filtered to contain only those for that category.
Thank you, Tina

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm