Cancel a combo choice (Access 2007)

Topic

New Reply

When a user selects a choice from a combo I want to give a choice to either accept the change or cancel the selection and return to the record with no change having been made.

I can’t see for the life of me how to achieve it – stupid because I’ve done some VBA – can someone bail me out, thanks

Reply | Quote

Replies

You can use the escape key, but this will undo all changes you have made to the record.

Reply | Quote

You could use code in the Before Update event:

Private Sub NameOfComboBox_BeforeUpdate(Cancel As Integer)
If MsgBox(“Do you want to save changes?”, vbYesNo) = vbNo Then
Cancel = True
Me.NameOfComboBox.Undo
End If
End Sub

where NameOfComboBox is the name of the combo box.

Reply | Quote

Thanks for the responses – whilst the escape key is a possibility, if the user recognizes an error, the method by Hans works fine and also allows for a customized message
I was well off the mark with what I thought I could do, but you’ve given me a couple more nuggets, Hans – thanks again

Reply | Quote