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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top