Related to Comboox previous listindex and previous selected value

[reena]

Hi,
I am trying to capture the listindex and value of the combobox before any change is made so where should I really do this in which event, I am doing this to compare the values after a new selection or change is made.

I have it presently in the Oncurrent event of form
public originalvalue as variant
where originalvalue = original value selected
public originalindex as integer
where originalindex = original listindex of the selected value of the combobox

Private Sub Form_Current()

originalindex = me.combo9.listindex
originalvalue = Me.Combo9.Column(1, originalindex)
End Sub

Can somebody help me.

Can somebody tell me whether I am doing right.

Thanks & Regards