thanks WayneS - just what I was looking for

I was planning to have a function that worked out if there was a gap in the numbers eg 76, then use that. I just posted an explanation of why...

I need to use the numbers because my customer initially blocks out a range of numbers, then adds records using these blocked numbers, or the next available number in the...