Hi,

I have an Access form linked to a table where the key in the table is an autonumber field. When adding a new record to the table using the form the autonumber field automatically displays. So if I'm adding a new record using the form say the autonumber is 10. I decide not to complete the record and cancel. I go back in to add a new record and the autonumber is now 11 not 10. So in the table it looks like record 10 is missing. Is there anything that can be done to avoid this? Thank you.