Having problems with INSERT syntax

See more:

Visual-Studio

VS2010

MS-Access

Well im trying to make a program just to add a record into the msaccess db,
and I found myself having problems with the INSERT into syntax error (Syntax error in INSERT INTO statement."

I would greatly appreciate if someone helps me with this code. Thnx.
I always get the error in the cmd.ExecuteNonQuery() part.

Dim cmd As New OleDb.OleDbCommand
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As StringDim ds As New DataSet


        If Not con.State = ConnectionState.Open Then
            con.Open()

        End If
        cmd.Connection = con
        cmd.CommandText = "INSERT INTO bene_records(f_name, m_name, l_name, b_date, add, home_num, cell_num)VALUES(@F_nameTextBox, @M_nameTextBox, @L_nameTextBox, @B_dateDateTimePicker, @AddTextBox, @Home_numTextBox, @Cell_numTextBox)"
        cmd.Parameters.AddWithValue("@f_name", F_nameTextBox.Text)
        cmd.Parameters.AddWithValue("@m_name", M_nameTextBox.Text)
        cmd.Parameters.AddWithValue("@l_name", L_nameTextBox.Text)
        cmd.Parameters.AddWithValue("@b_date", B_dateDateTimePicker)
        cmd.Parameters.AddWithValue("@add", AddTextBox.Text)
        cmd.Parameters.AddWithValue("@home_num", Home_numTextBox.Text)
        cmd.Parameters.AddWithValue("@cell_num", Cell_numTextBox.Text)


        cmd.ExecuteNonQuery()

        

        con.Close()