auto fillinn textbox

[Barth Smith]

I'm creating a database to keep track of some invoices.
I want to use a form to create a new invoice.
The form is linked to the table tbl_customers.
In the txt field "Invoice number" I want a new number for every invoice. The numbers should look like * 2002/xxx" where X is the number for the invoice.

Thanks

 

[Alexandre]

have a look to the ongoing thread:
Never store a built ID, just display it. Ex ample of Year-Number ID