Auto Id Generator

[Quique79]

Hi!!

I'm designing an form that will work as an Invoice, my problem is, that I want that every time I add a new record (or invoice) the Invoice No. will be generated automatically.

I was trying to obtain this number from a separated table (InvoiceNo) and inside the Invoice form to put a field with this value and when I press save button, save all info in the Invoice Table and increase the InvoiceNo., so, everytime it will be automatically, but, when I try to do it but it doesn't function... any tip or hint?

Quique79

 

[MichaelRed]

You migh look at the example in faq700-184. It was written for MS. A. '97, and is NOT the easiest to implement, but it DOES have some commentary / documentation.


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[sdimaggio]

Try this

Put the following code in Default Value under the Data tab in the properties section of your text box.

=DMax(" [Invoice Number] ","YOURTABLE&quot+1

 

[Quique79]

Hey guys.. thanks for your help Quique79