VBA Event on Batch new line

Shane Dalgleish — Fri, 29 Aug 2008 01:30:20 GMT

We're wanting to run a duplicate check on each line of a constituent batch, as the data is being entered, so that at the end of the batch we know that everyone of the records has been checked.

Currently, we have in the user procedure to click on each line, then do a "Duplicate Search For xxxxxx" in the menus, but users being users, this isn't always done to an acceptable standard. So we want to force them to do this, every line.

I have tested out all of the VBA events to see when they are triggered, and these ones I don't think ever fired in my testing:
-    Batch_BeforeBarCodeLookup
-    Batch_BeforeValidateRecord2
-    Batch_BatchException
-    Batch_AfterPostRecord
-    BatchVBARecord_HandleException
Certainly none fired as each line was being entered....

Does anyone know of an event that we can capture, or a way to automatically run the duplicate check on each line during entry instead of on the entire batch?

VBA/API

VBA Event on Batch new line