Cancel adding a Record Based on a Control Value

D

dch3

I'm trying to figure out how to cancel/abort adding a new record if the user
selects a particular value from a comboBox. The form is a continous form
where the user can go directly to the comboBox and select one of three
values. If the user selects a specific value, I need Access to run code and
based on the result abort adding the record.

I just can't figure out in which event to place the code.
 
D

dch3

Never mind...

The code needed to be in the control's AfterUpdate event and uses the
Me.Undo method of the Form to undo the change
 
Top