I am new to this forum.

I have the following environment: an Access frontend client that is connected to a database on SQL Server (backend). I would like to use an Access form to enter data that is associated with a specific ID number (in database Table). Ideally the ID will automatically increment when an INSERT is made to the Table. The vba code (based on the SQL query) I wrote is the following:

```
Option Compare Database
Option Explicit

Private Sub List0_Click()

Dim HelloWORLD As String
Dim dbsCurrent As Database
Set dbsCurrent = CurrentDb

CurrentDb.Execute "INSERT INTO Table1 (TESTING_1, TESTING_2) VALUES (" & 9 & "," & HelloWORLD & ")"
End Sub

```

The code is compiling but it is not appending the Table1 like it is supposed to do. Please Help.