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?
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?