Number automatically without using autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a five digit number assigned to information entered and
sequentially incremented each time.
Autonumber can be used, according to the book and Help, but neither explains
how to specifically accomplish it.
The numbering must start with the five digit number I put.
Any suggestions?
 
You use an Autonumber field in your table to represent a Primary Key. It
really should only be used for that purpose and be totally invisible to the
user.

You can (and should) set up your own auto incrementing field. Just use a
Number (Long Integer) field in your table.

In your form, you can use the DMax() function to return the highest value
currently in your database and increment that by 1 when adding a new record.

Steve
 
Back
Top