Automatic numbering system

[Nick]

I am designing a database that will give a unique for
digit number (starting with 0001) to records. When the
user puts in the specified details i want them to click a
button on the form and for a text field to display the
unique number to them plus entering it into the field in
the table. How can i do this?

Cheers

Nick

 

[Roger Carlson]

On my website is a small sample database called "AutonumberProblem.mdb"
which show one solution.