Carl,
I would setup table to handle this for me. Make new method and a new property on your form. Call your method select the table get your number and hold it to variable and replace the field number + 1 pass that variable to the property and you can use it when you need to on your form. I also would lock the record where you getting your number so you have no dups.