please help -- inserting with autonumber key (1 Viewer)

[shrndegruv]

Hi all

In my VB code I need to create a row in a table that has an autonumber field as the primary key.

How does one specify that in SQL.

I have the following as my sql -- I dont know what should go in the [autonumber] spot

"INSERT INTO [WindowCondition](ID, RoomID, UnitNumber, RoomType)" _
                & "VALUES ( [autonumber]," & cID & ", " & uNumber & ", 'Kitchen')"

when I dont specify to insert ID, I get a key violation error.

thanx

 

[pdx_man]

I believe the answer is nothing ... notta:

"INSERT INTO [WindowCondition](RoomID, UnitNumber, RoomType)" _
& "VALUES (" & cID & ", " & uNumber & ", 'Kitchen')"

 

[shrndegruv]

this was never the error in the first place -- it was a relationship problem...