autonumber

[Arrowx7]

hello,
I am using SQL INSERT INTO where I insert values from my form Me!value1 etc
I have an autonumber in the table where I am using INSERT INTO, and when I exclude the autonumber it says that the number of columns does not match. I tried assigning a number manually in SQL and it works fine, but I can't use autonumber anymore. Is there a way to use autonumber and still do INSERT INTO or is there a way I can find the highest number and put the next highest in there through VBA?

Thanks in advance

 

[WayneRyan]

Arrow,

Just don't reference the AutoNumber in your "Insert Into" statement. You
are not really inserting it. Access will assign it for you.

Wayne

 

[Arrowx7]

thank youuuu