drop down box assigns values to TextBox - unbound value only changes one time

[bill s]

Hello all,

I have a drop down box that populates 3 fields,

SELECT LEGAL_NOTE , 'this is bound to drop down
FY, 'this is unbound to a text box
LEGAL_CITE ' this is bound to a text box
FROM R_LEGAL_CITE

I have a OnChange event on the dropdown control that works fine, however, me.txtLegalFy is unbound and is display text box only. It works on the first drop down selection, however, if I change the drop down selection, it will not update. It maintains from the first selection. Me.txtLegalCiteMFR is bound and changes without issue on when the dropdown selection changes.

Private Sub cmbLegalNote_Change()
Me.txtLegalFy = Me.cmbLegalNote.Column(1)


Me.txtLegalCiteMFR = Me.cmbLegalNote.Column(2)
End Sub

Any suggestions? I have tried many different approaches.

Thanks

[June7]

I have never used OnChange event. I use AfterUpdate. Not sure it will make a difference but try it.

[bill s]

I have never used OnChange event. I use AfterUpdate. Not sure it will make a difference but try it.

Bingo! Thank you! That worked. I had tried that but didn't remove the "OnChange" code. AfterUpdate is the way to go.

thanks.
Bill