Abort a record

[Michael Kintner]

I am checking values inside of a table using the change event. If I do not
like a value I want to abort the insert of the new record. (like pressing
the escape key)

How do I do this inside of VB on the change event?

Thank you in advance for your help,
Mike

 

[Rick B]

If you use the BEFORE UPDATE event, then you can simply "cancel" it.

 

[Michael Kintner]

Ok, so how can I cancel it, or abort the record insert?

Is it Recordset.cancel??? I don't know.

 

[Rick B]

I believe it is..

cancel

or

cancel=true