Limit a set of sequence numbers

[Kevin Baker]

Hi Everyone,

I have a Purchase Order Field that will begin with 9700 and end at 9899. I
would like to have code that will take the previous records PO number and
add 1, but if the last PO number is 9899, then the next would be 9700.

Thanks
Kevin

[Peter Russell]

Kevin Baker previously wrote:

Hi Everyone,

I have a Purchase Order Field that will begin with 9700 and end at
9899. I
would like to have code that will take the previous records PO number
and
add 1, but if the last PO number is 9899, then the next would be 9700.

Thanks
Kevin

You would have to create a table to hold the last allocated number; read
the number when you wanted it and then update it accordingly. Enter the
starting value of 9699 into the one record in the table.

Air-code snippets:

set rs = currentdb.openrecordset ("mytable",dbopendynaset)
rs.movefirst

Myval = rs("LastNo")
if myval = 9899 then
myval = 9700
else
myval = myval+1
end if
myformfield = myval
rs.edit
rs("lastno") = myval
rs.update

set rs = nothing

Regards

Peter Russell