Save as new form using command button

[acnovice]

Hi,

I want to bring "Invoice" form with old information and save it as a new "Invoice" with a new Invoice Number.

I gave unbound combo box to bring the old data from Inovice table but I can't change the "Invoice" number because the data type is set to "Autonumber".

What do I have to change it ?

Thank you for the answer.

 

[TheAceMan1]

How are ya acnovice . . . . .

To get a new Invoice Number, you need to [blue]append all fields for the record[/blue] (save Invoice Number) [purple]to a new record[/purple], where it will receive a new number (just like adding a new invoice)!

See Ya! . . . . . .

 

[alvechurchdata]

When ADO first came out there was a page in MSDN showing the differences between Old and New. I can't find it in my copy this morning.

Geoff Franklin

http://www.alvechurchdata.co.uk