stumped about addnew

[kari]

i have a form in access to which i've attached an event module to allow users
to update the underlying table directly from the form (using AddNew). the
underlying form is just a list of contractors with an AutoNumber index. For
some reason, when users add a new item --the AutoNumber reverts to "2",
instead of assigning the next incremental number. I have the autonumber set
to assign incrementally (not randomly). for the life of me, i cannot figure
out why it is doing this. any thoughts?

thanks in advance

kari

 

[RobFMS]

Kari

Do you know if there is an hidden field that is pushing the value of "2"
into the autonumber field? Oddly enough, you can, in fact, "push" a value
into the autonumber field.

Here's an example:

Have Autonumber field start from a value different from 1
http://www.mvps.org/access/tables/tbl0005.htm

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-