Can anyone tell me how to amend my query please to account for the fact that my first field is an autonumber

Thanks

Gibbo

[VBA]
strSQL = "INSERT INTO tbl_Test VALUES ('" & _
Me.TextBox1 & "', '" & _
Me.TextBox2 & "', '" & _
Me.TextBox3 & "', '" & _
Me.TextBox4 & "', '" & _
Me.TextBox5 & "')"
cn.Execute strSQL
[/VBA]