invoice number
sorry table Invoice
"Steve" wrote:
Look again at Fred's response. Just as he says, you don't want to create the
invoice number in the print event. Look again at my response. I suggest you
create the invoice number in the AfterUpdate event of the InvoiceDate field.
Steve
"cjgav" wrote in message
...
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.
|