Combobox automatically reposition ListIndex

Hi, I have situation with 2 user forms - A calls B. Form A just list records, and form B is called to edit single record. Data comes from the database. Simple, works well.
One of the fields is called colour_id and user picks it value from the combo box, which shows 2 columns - colour_id and colour_name, bound to column 1 - colour_id.
As I'm passing colour_id from form A to form B, I want combobox to automatically reposition and show me matching colour_name.

Instead, what happens is that, combo box shows me my colour_id, and then I need to programatically reposition it to matching colour name.
My question is - shouldn't this happen automatically like in Access for example?

Cheers
Jack

Hi jacknomiz

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE and an AFTER result to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window

Tell me jacknomiz

Any reason why you are using 2 userforms calling the same information. Why not just one and combine the required info as per sample.

thanks for the title change

Hi Jacknomiz

Upload a sample workbook so that we can see the result required.
If you select [4] do you want another combobox to display green..
Why would you want to read the Table in a userform when the Table is displayed in your sheet.
As per sample you select [4] from ComboBox dropdown list. This then displays [4] in textbox1 and [Green] in Textbox2...You can then edit textbox1 and textbox2 and have a button that makes the changes to the Table.

Here you go...play around with this.
If you want to edit, select choice from combobox and change colour in textbox2 then press edit.
If you want to add, make sure all boxes are clear, enter a no into textbox1 and a colour into textbox2 then press add.