Very Computer

Gary,

Quote:>When adding a new record to a recordset that has an autoincrement id the
>value increases even if the the process of adding the record was cancelled.

Quote:>I would like to put the number back to it's previous value if I cancel the
>update to the new record.

Basically the numbers generated in an autonumber field aren't supposed
to "mean" anything. They happen to increment upwards by one, but their
PURPOSE is simply to provide a guaranteed unique value which is
suitable for use as a primary key or unique index. They should not be
used as pseudo-record numbers or as series numbers, such as
CheckNumbers or InvoiceNumbers and so forth.

-- Jim Ferguson, FMS
   http://www.fmsinc.com

Gary -

Quote:> autoincrement id the back to it's previous value

Anybody heard different ? (Hey MS ... you listening ?)

pCb

[ Pete Baxter                   540.785.2727
[ Distributive Data Systems     540.785.2728 fax
[ ----------------------------------------------

When adding a new record to a recordset that has an autoincrement id the
value increases even if the the process of adding the record was cancelled.

I would like to put the number back to it's previous value if I cancel the
update to the new record.

How is this done?