Macro for sequential invoice numbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a macro within an invoice so each time I open the invoice template the macro automatically advances to the next sequential number?
 
James,

This is not a job for a macro. If your invoice "template" is a single
view form, you can set the Default Value property of the InvoiceNumber
textbox to the equivalent of...
DMax("[InvoiceNumber]","Invoices")+1
(obviously substitute the names of your own actual table and field
names).

- Steve Schapel, Microsoft Access MVP
 
Back
Top