Invioce auto number

[xpaccess]

how can I get an unbound text box to auto number (i.e. 1,2,3) and so on as new invoices are generated?

Any help would be GREAT.

 

[FoxProProgrammer]

Assuming that the invoice number is stored in a table, just retrieve the highest number from that field, add 1 to it, and assign it to the value of the text box. You could do this before saving the record or when you display a new record in the form. There are several ways to retrieve the highest number from a field in a table. Is this what you want to do? It would be easier to use a field that is bound to an Autonumber field in the table, but I guess you are using an unbound field for a reason? dz
dzaccess@yahoo.com

 

[xpaccess]

Thanks but I sold the problem a few minutes ago.