inserting autonumbers in SQL.

[Karen Hill]

I have a two value table where the first field is an autonumber. I
wrote an SQL statement in visual basic for applications to insert but
it fails.

This is the code:

DoCmd.RunSQL "INSERT INTO Table1 VALUES(,cat);", True

The first one I didn't include a value because it is an autonumber and
I expected JET to automatically put in the next value. How can I get
it to work?

thanks.

[Salad]

Karen Hill wrote:

I have a two value table where the first field is an autonumber. I
wrote an SQL statement in visual basic for applications to insert but
it fails.

This is the code:

DoCmd.RunSQL "INSERT INTO Table1 VALUES(,cat);", True

The first one I didn't include a value because it is an autonumber and
I expected JET to automatically put in the next value. How can I get
it to work?

thanks.

Dim strSQL As String
strSQL = "Insert Into Table1 (FieldName) Values ('cat');"
DoCmd.RunSQL strSQL

You don't need to concern yourself with adding an autonumber. That is
done automatically when you insert the record.