How to code an Invouce Number

D

Dave

I have a bad habit of using "autonumber" too much and in the wrong places.

SO I need some suggestions for creating an invoice numbering system that
increments by one with each new order but does not increment if the order
was not completed.
And maybe some way to show as "voided" if an order was cancled.

Thanks much,

dave
 
R

ruralguy via AccessMonster.com

You can just use a DMax() in the BeforeInsert event and in the BeforeUpdate
event IF Me.NewRecord.
 
Top