sequencial number not autonumber

Hi Guys,

Looking for help with this issue. I have an invoice form with a field 
[invoice_num] and want, on save, to create a sequential number. If  user 
cancels the record any point before save I do not want to save the number
to 
ensure sequence for invoices is consistent.

Any suggestion would be most helpful.

TIA