CODEWITHSUNDEEP
databasevbams-access
Bob P
Bob P

Reputation: 237

Filtering using a combo box value in Access

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

Upvotes: 0

Views: 301

Answers (1)

Jay
Jay

Reputation: 2129

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.

Upvotes: 1

Related Questions