Combo Box

[dr223]

Hi,

I have this code (shown below) which selects a value from the combo box which is stored in another textbox field. The code works well, however, what I want to do is, when I have selected the value from the combo box I want it to disappear rather than remembered.


This is because when I move to the next record it still shows what I selected in the previous record. I would preferred it to be empty and make me select again from the combo box.

Private Sub cbonation_AfterUpdate()
Nationality = Me.cbonation.Column(0)
End Sub


Any help much appreciated...

Thanks

 

[boblarson]

Just use the form's On Current event to clear it:

Me.cbonation = Null

 

[dr223]

Thanks Boblarson