Combo Box After Update

[mtagliaferri]

I have a third record field that should be updated after a selection is made in a combo box as:

Private Sub LstCountry_AfterUpdate()
Me.BillCurrency = Me.LstCountry.Column(4)
End Sub

The BillCurrency does not get populated, however if I manual type a value in BillCurrency and then I change the value in the Combo Box the BillCurrency field clears the value.
Any suggestions?

 

[Ranman256]

That means you set it to a value not in the list. Bound column.
If the combo has 2 columns,
Bob, 3

But the bound column is 2, so you can't set the combo to Bob, you will get blank.
You must set the the combo to 3,THEN Bob will show.

 

[mtagliaferri]

Thanks very much

 

[prowaseem]

good suggestion