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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Entry Form and Auto Number ID 2
Access 2003 Autonumber 4
Create custom autonumber field 5
Last record plus 1 1
Simple Ref number for a form 2
Record-Locking remains open after closing 0
Access Automatically Send a notification email once a record is added 0
Primary Key Field (Auto Increment) is Creating Duplicate Record Va 10

Back
Top