We help IT Professionals succeed at work.

Populate a box with values dependant to a combobox

Michael Noze
Michael Noze used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
Commented:
A question with a little more ...."substance"
OK ..check my attachment
Planning.accdb

Author

Commented:
Hi John Tsioumpris,

It looks good!

Thank you.