Access Cascading combo/query in table/subform

Sep 21, 2017
Reaction score
I have 3 columns in tbl_Sales_Details: Product, Range, Outer. What I want to realise is that when product is selected, then available product range options shows in the Range Field, and then depending on the range selected, relevant outer options show in the the Outer Field.

For example:

when I choose Pepsi, the available 3 options (Original/Diet/Zero) shows in Range, and then according to RangeID, available options of Outer shows in dropdown list for selection.

Can it work out without using VBA? If not, would be appreciated to have the code.

Please help!


    27.7 KB · Views: 102

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question