Aborting an automatic insert

[GreenFella]

Is there any way that an automatic insert can be aborted from the Before Insert Event.

I have a situation where records are being inserted into a status table automatically. As part of the before insert I am checking to make sure the effective date of the transaction falls within a prescribed range.

If it does, great, the insert can proceed.

If it does not, I would like a way to stop the insert from taking place after having displayed an error message explaining why.

Any and all suggestions will be greatly appreciated.

Thanks
Greenfell

 

[PHV]

Simply set the Cancel argument to True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[GreenFella]

Cool.

I knew it had to be something straightforward but just couldn't figure out what it was.

Thanks for your help