How to code an Invouce Number

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
You can just use a DMax() in the BeforeInsert event and in the BeforeUpdate
event IF Me.NewRecord.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber is reusing previously assigned numbers-creating duplica 3
How to Increment Number Format 1
Invoice Form Question 4
Changing Data Type from Number to AutoNumber 2
Add incremental character to cell value at change in value 449becomes 449-A 510 becomes 510-B 2
how to have a form that generate invoice no. 2
Codes _ ineed help please 5
Click a subform field to open relevant form 5

Back
Top