Forum Discussion
Help with selection and sub selection in Access
I’m trying to learn access to making tracking material orders for my job site much easier. I’ve created a table with categories, another with units of measuring those materials, and another that has ...
You need to get the material, category in the 2nd dropdown and set the criteria for category column in material dropdown to reference the value from 1st dropdown of material using the below syntax:
=Forms!formname!controlname
Check the below links for solutions
https://access-excel.tips/access-combo-box-value-depends-another/
https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-create-simple-cascading-combo-boxes-in/3ce61e3b-44bc-422e-9b5c-1bd2644fe8ca