Cancel adding a Record Based on a Control Value

  • Thread starter Thread starter dch3
  • Start date Start date
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.
 
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

Similar Threads

Query Parameter using multiple options 0
Need combo box to refresh when moving to new record 2017 1
Create a yes no message on a command button on click 0
Form BeforeUpdate Ignoring Cancel 3
Preventing Multiple Records from being Deleted via Record Selector 4
Cancel Open Report from a parameter form 7
Manipulating .NotInList Event/Add Data to Combobox 2
Record insert/delete anomaly 0

Back
Top