I’m using the before updating event to activate a macro that runs some checks on the record which I’m about to insert into my database from a form.
IMPORTANTLY: If the checks fail I don’t want the updating to go ahead
My question is how to I achieve this?
My thoughts are to create the macro as boolean function and return FALSE if the checks fail (and hopefully halt the update) or TRUE it the checks are passed (and then allow the update to proceed).
Is this the correct way to proceed or is there better/correct alternative.
And on a more general point can this method (or the better/correct one) be used with any/all BASE form events to communicate with the underlying processes causing them to halt or proceed?