Hitting "Escape" to Clear Combo Box Deletes New Record

[techchallenged]

When a user makes a selection from a combo box, then hits the "Escape" key to clear this selection, the new record he is creating is deleted. If he is modifying an "existing" record, his changes are deleted.

My combo boxes are on a form (with tabs). I have combo boxes which use "value lists" and also combo boxes which use "lookup tables". The new record, or changes to an existing record, are deleted regardless of whether the combo box is based on a "value list" or a "lookup table".

 

[Rohdem]

I believe this is normal. The user needs to press the delete key when the selection is highlighted to clear the selection. When the user changes the combo box, the record goes into edit mode (the pencil appears in the record selector) until the user goes to another record, or the current record is saved via VB code. While in edit mode, pressing escape will discard the changes and take the user out of edit mode.

Mike Rohde
rohdem@marshallengines.com