Unbound text box on ALL records display new data!

[gusbrunston]

The choice in a combo box is saved in one field. The data from the second column is displayed in an unbound text box.

Continuous forms.

When choice is made from combo box for latest record, the correct data from the second column is properly displayed in an unbound text box, BUT all the visible previous records have the same new data substituted in the same text box.

Here's the code from the combo box After update:

Private Sub cboPayerPayeeID_AfterUpdate()
    Me.txtPPName = Me.cboPayerPayeeID.Column(1)
End Sub

Anybody???

:-I

Gus Brunston
An old PICKer
padregus@home.com

 

[seaport]

My suggestion is to make the unbound field as a bound field. Create an extra field in the underlying table.

I cannot see any other way out.

Seaport

 

[gusbrunston]

Dear Seaport:
I sea what you mean. I'll try that. Thanks.
Gus Brunston
An old PICKer
padregus@home.com