numbering records

T

tom

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.
 
K

KARL DEWEY

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.
 
C

Charles Calvert

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?
 
Top