How to do befour update only once in the loop

[Magnus1982]

Hi ,



This is my small problem.

I have control name ctInput (bounded with table). In this field I am typing or scanning number e.g. KKK0001.
After update is a loop which:
1. Splitting KKK0001 to other controls ctCp1 for KKK and ctCp2 for 0001 ,
2. Adding 1 to ctCp2 (and i have 0002)
3. Joining together full number KKK0002
4. Placing final value to ctInput.
Loop is doing that 15 times . It is mean loop creating 15 records in tables with next numbers from KKK0001 to KKK0015

I need to place code before update which will check that KKK001 exist in other table. I know how to do that but:

If I am placing code before update event is checking not only once but always when loop is working .I just need to do that once for first number which I am typing or scanning not for numbers from loop.

Thanks for help

[pbaldy]

What does your code look like? The check should be able to be placed before the loop so it only executes once.