Hi Steve
Thanks for that not sure were to put the Dmax formula so it updates the
invoice number when I print also this number would need to be stored in the
invoice table and not change .

"Steve" wrote:

Did you read my suggestion above?

Steve



"cjgav" wrote in message
...
Hi
My problem is I donot know how to generate a number without using autonum
which is unsuitable .

"Fred" wrote:

Under my described thought process, you would create the record in the
invoice table and create an invoice number at the time that the invoice
event
occurred. The first printing would happen a few seconds AFTER that
process.
And later you could print extra copies of that invoice if needed.