A
alan
there is no way to manipulate the autonumber function,
however you can create your own function that will
increment by what ever you want. Use the DLast funtion for
the feild and add 5 to it. Place this in the after update
property of whichever feild gets populated first. So it
would look like this: me.txtId = DLast("IdFeild","Table")+5
however you can create your own function that will
increment by what ever you want. Use the DLast funtion for
the feild and add 5 to it. Place this in the after update
property of whichever feild gets populated first. So it
would look like this: me.txtId = DLast("IdFeild","Table")+5