I want to insert data into an Access table and have an autonumber assigned to it. Passing a null value doesn&#039t work. Ignoring the field in building my INSERT INTO query doesn&#039t work. Any ideas on how to insert a new row of data and have an autonumber generated for that row? I have the autonumber field identified as the primary key.<BR><BR>Here&#039s my INSERT INTO query:<BR><BR>"INSERT INTO tbl_test VALUES (&#039" & strNum & "&#039, &#039" & strID & "&#039, &#039" & strName & "&#039)"<BR><BR>where strNum is the autonumber field.<BR><BR>I appreciate any help! Thanks.<BR><BR>Tim<BR><BR>Tim Slavin<BR>tim@slavin.com