Syncronising two Form drop downs and displaying the contents in a text box

[Rabbitoh]

Scenario:

I have two columns on a worksheet, the contents of which relate to each other e.g.

01 Name1....etc.
02 Name2....etc
03 Name3....etc

I have a Form with two drop down lists and one text box.

The drop downs relate to the entries in the two columns respectively.

The text box relates to the contents of only the second column.

Objective:

I want to select an entry from either drop down list (e.g. "01" or "Name 1....etc") and have the full contents of the corresponding second column only display in the text box so that I can EDIT it.e.g. if I select "02" then the text box displays "Name 2...etc".

If however I select "Name 2..etc" from it's drop down list first, then I also want the other drop down list to syncronise and display the corresponding column entry e.g. "02". (could even have them going both ways)

Can anyone provide me with the code to do this please?

 

[MStef]

Look at "DemoSyncTwoA2002.mdb" (attachment).
I think it is what you need.