PLEASE HELP...easy question

[sksbizkit]

All that i'm trying to do is INSERT values from a form into a table called "DEPENDENTS" using access/sql...its just not updating my table...here is the code..PLEASE HELP

Private Sub cmdAddDependent_Click()
Dim sSql As String
Dim dbThis As Database
'
Set dbThis = Access.CurrentDb


sSql = "INSERT INTO DEPENDENTS VALUES('" & cboAssociate2.Value & "','" & cboAssociate2.Value & "', '" & txtFirstName.Value & "', '" & txtLastName.Value & "', '" & txtB.Value & "'," & txtNumber.Value & ",15)"


dbThis.Execute sSql

End Sub

 

[dhookom]

At least one reply in a more recent thread from you.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]