increment by 1

[martyn]

I have a form , each record has an autonumber but also a number I gave it '

 

[Rick B]

One post per question please.

http://www.mvps.org/access/netiquette.htm


PLEASE STOP POSTING YOUR QUESTION OVER AND OVER AND OVER. ONCE IS
SUFFICIENT.

 

[Barry Gilbert]

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

 

[Tim Ferguson]

I'm not sure why you need two autonumber fields,

Read on: it's not an autonumber field he or she wants.


Tim F