Synchronizing 2 comboboxes

Question

Please help!

I have 2 comboboxes, both are bound to the same Access table1. ComboBox1 is bound to Column1 and ComboBox2 is bound to Column2. Combobox1 drop down has 1, 2 and 3 to select. ComboBox2 has A, B and C to select. How do I synchronize/link the two ComboBoxes to show the same corresponding index. For example if I select ComboBox1 number 3, ComboBox2 must change to C automatically.....and vice versa?

Thanks