I have two text boxes (text1 and text2) linked to 2 data controls (data1 and data2) text1=data1, text2=data2, k?

I also have a combo box. When a value called "selected" is in the combo box, I want to change the tables that the data controls point to from table1 to table2, and change the fields that the text boxes point to from field1 to field2.

How would I do this?