Data type mismatch in criteria expression

[DMG2000]

Everytime I try to call, or add to a primary key with a database, I get this error " Data type mismatch in criteria expression.", I know it has to be possible to get or update the primary key autonumber, but why isn't this working?
Code as follows:
sql= "insert into orderitems (orderid,productid, qty,priceperunit) values ('" & orderid & "','" & acart(i,0) & "','" & acart(i,1) & "','" & rsprice("saleprice&quot & "')"

Note: Bold is the primary key

Appreciate any thoughts!

 

[WP]

It's NOT possible to update the Autonumber field !!!

Autonumber tales the next number you don't need to include it in your SQL INSERT INTO statement.

WP

 

[DMG2000]

Thanks WP:
I figured out what the error was. I was using adOpenDynamic when I should have been using adOpenKeyset...took long enough but after looking at the code for hours, it came to me. It wasn't that I wanted to add a new autonumber, but call the autonumber from the recordset based on the new entry, and then set it to a variable, but using adOpenDynamic, it resulted in the error. Go figure