Inoice numbers

[Khalil Handal]

Hi to all,
What is the best way to obtain an invoice number for each invoice?
These numbers will appear when printing the invoice.


(Invoice numbers are supposed to be unique and serial)
Khalil

[CJ_London]

investigate the DMax+1 concept

newInvNum=DMax("invnum","tblInvoices")+1

If being generated at the time of printing, you need to consider whether you are printing one invoice at a time or multiple invoices. And what happens on a reprint? - either for a copy or in the event the printer fails and you need to start again

[mike60smart]

Hi Khalil (Ajax beat me to it)

The best method is use the following:-

In the Before Update of the Form

Me.InvoiceNr = Nz(DMax("InvoiceNr","tblCustomerOrderdates"),0) + 1

[Khalil Handal]

Hi,
Thank you both.
Got it