Text Box retrieving data from combo box on another form

[Guest]

I have a text box on one form trying to pull the value from a combo box on a
parent form. The bound column of the combo box on the parent form is 3. If
I define the control source of the text box such that it pulls the value of
the combo box on the parent form, it displays the first column of data and
not the bound column of that form. The text box is displaying the value in
column 1.

 

[fredg]

I have a text box on one form trying to pull the value from a combo box on a
parent form. The bound column of the combo box on the parent form is 3. If
I define the control source of the text box such that it pulls the value of
the combo box on the parent form, it displays the first column of data and
not the bound column of that form. The text box is displaying the value in
column 1.

Using an unbound control:
=forms!OtherFormName!ComboName.Column(2)

Column(2) is the 3rd column.
The other form must be open at the time.