Link to home
Start Free TrialLog in
Avatar of Michael Noze
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
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael Noze
Michael Noze

ASKER

Hi John Tsioumpris,

It looks good!

Thank you.