When I am inserting records into an Access database using insert into TABLENAME values(), how do I access the next value of an AutoNumber field. For example, I have an Access database on my web site to enter time sheet data, and I want to add a record. I can't use the .AddNew method, so I am trying to use an Insert query. The first field is an AutoNumber field as a Primary key. How do I insert a record and tell access to get the next value of the AutoNumber field?????