increment by 1

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

Guest

I have a form , each record has an autonumber but also a number I gave it '
 
I'm not sure why you need two autonumber fields, but if you want to require
the user to type in the next highest number, why not do it for them and
prevent them from overriding it?

In the Default property for that field, put in something like:
=DMax("SID","MyTableName") +1

Then lock the textbox to protect it.

Barry
 
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

AutoNumber Field (Access 2007) 5
Autonumber starting point 4
Append Query and Autonumbering 1
Remote Databasing - User Implementation and Incremental Numbering 3
Remote Databasing Problems - Design and Incremental Numbering 1
Yet Another Autonumber/Incremental Key Question 2
automatic numbering 3
Access Autonumber NOT Unique 6

Back
Top