Invoice number

[Derek Brown]

Hi all

Whats the best way of producing a sequential invoice number on a form
allowing for the fact that an invoice may be cancelled half way through and
not deleted by the user which would throw out the sequence. At the moment I
am using the Max funtion to find the largest number in the invoice number
field and adding 1. Seems a bit clumbsy to me. Also how do I delay entering
a new number (Programatically) until the user has entered some data in any
other field. If I have a number calculated by the forms on current property
and the user changes their mind I think I am right in assuming that a new
record will be created but with only an invoice number in the whole record
again throwing out the invoice number sequence

Help

 

[Allen Browne]

Use the BeforeUpdate event of the *Form* to calcuate the number.

That's the very last event before the record is saved, so it's the last
chance you have to calculate and assign the next available number.