Michael Noze
asked on
Populate a box with values dependant to a combobox
Hi Experts,
I'd like to know if it's possible to take the value of a combobox, search the value in a table and then return values related to that value?
IE:
1. In frmInspection, we select the value "3035" and then we click on the button "Specification".
2. The same value is applied to the cbo in frmSpecification.
3. A box containing the column C1, C2, C3, C4, C5,C6 is populated, (3082, 3052, 3034, 3035, 3150,3157) (Vlalues from the same row as "3035")
If 3149 was in the combobox, we would have: 3069, 3149, 3114, 3159, 3061, 3031 instead.
Is there a way to do this?
Equipment.xlsx
Planning.accdb
I'd like to know if it's possible to take the value of a combobox, search the value in a table and then return values related to that value?
IE:
1. In frmInspection, we select the value "3035" and then we click on the button "Specification".
2. The same value is applied to the cbo in frmSpecification.
3. A box containing the column C1, C2, C3, C4, C5,C6 is populated, (3082, 3052, 3034, 3035, 3150,3157) (Vlalues from the same row as "3035")
If 3149 was in the combobox, we would have: 3069, 3149, 3114, 3159, 3061, 3031 instead.
Is there a way to do this?
Equipment.xlsx
Planning.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It looks good!
Thank you.