Filtering using a combo box value in Access

Question

I have 2 combo box's that are populated from a table and allows the user to select a product from that table to convert into smaller pieces of stock. What I need to do is filter the products in combo box 2 based on a section of the Product Code selected in combo box 1. Is this possible and has anyone any pointers?

Thanks

Answer 1

You should be able to base the binding of combo box 2 on the selected value of combo box 1. Update the binding of combo box 2 so it references combo box 1, then re-query.

This link http://www.baldyweb.com/CascadingCombo.htm has a couple of methods in that should get you started.