i am experimenting with forms and the add and delete buttons. currently the
pirmary key is a long integer that autoincrements. i am starting off with a
new table with 10 records, when I add a new record, the primary key is
assigned a value of 11. if i delete it then add a new record, it is assigned
12. how can I tell it to use 11? or to calculate it based off the last
greatest value.

so now my keys go from 1-10 and then jump to 26 and start counting there.

Thanks...Steve

Steve:

Sorry.
It can't be done in any simple manner.
If you were desperate you could do as follows.
Copy the table.
Paste, but when asked say structure only.
Write a query that appends the old table to the copy, leaving out the
autonumber field.
The copy will now have continous autonumbers.
You could then delete the original table and rename the copy.

You could write a macro to combine all the above steps. For a small
table this would be practical. For a large table with lots of add and
delete activity, it could be quite slow to run.

Good luck
Ira Solomon

On Tue, 05 Apr 2005 06:59:56 GMT, "Steve" <1@2.com> wrote: