numbering records

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

Guest

I'd like to start my database records at 1000 and increment by one each time.
Also, When I create a form to add a new record, how can I make the record
number be the next available? Thanks in advance.
 
You can build a query to pull one record that is your field sorted
descinding. Then have the textbox on the form default to that plus one by
using DLookup as source.
 
I'd like to start my database records at 1000 and increment by one each time.
Also, When I create a form to add a new record, how can I make the record
number be the next available? Thanks in advance.
Click to expand...

Why not use an autonumber field?
 
Back
Top