If the Table has been setup right the autoumber will look after its self.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Do you need to get the value to use somewhere else, or are you concerned about it assigning the correct number?
Autonumber fields will not let you assign data to them - they will assign data to themselves automatically.
In other words, when you insert a new record, the autonumber field will automatically increment to the next number (hence the name).
insert into table members member_id, member_name values ( xxxx, "Bob")
insert into table members member_name values ( "Bob")
As a matter of fact, even if you cancel the transaction, the number that was assigned is still "used up" - the next time you insert data, you'll get the NEXT number. This is because Access assigns the "autonumber" as soon as a record is initiated, just in case multiple users are in there at the same time.