[RESOLVED] Cancel Combobox Change

[terbs]

Basically have a combobox and on the Change event im bringing up a MsgBox asking whether I am sure I wish to change the value, which is fine. Just need some code to return the combo back to its previous value

cheers

If MsgBox("Status Change: Go ahead with changes?", vbYesNo + vbQuestion, "Status Change") = vbNo Then
    
//Here...... ''

End If

[Br1an_g]

Basically have a combobox and on the Change event im bringing up a MsgBox asking whether I am sure I wish to change the value, which is fine. Just need some code to return the combo back to its previous value

cheers

If MsgBox("Status Change: Go ahead with changes?", vbYesNo + vbQuestion, "Status Change") = vbNo Then
    
//Here...... ''

End If

you will need to write the previous value before the change

either using before update or on click.

you will then have the value after update, and your msg box decision will be able to write either value back to teh combo box.

[terbs]

yeah I had a play with this idea myself im just unsure how to execute it.

I declare a the variable "tempstatus" on the onClick event,

Dim tempstatus
 
tempstatus = me.cmbStatus.value

but when I call it on the onChange event it says variable not defined

[terbs]

figured it out, just applied the value of the combo box to a hidden field on the GotFocus event..

cheers