Receiving error "no value given for one or more parameters"

See more:

VS2015

Hi Friends,

I am developing project in Visual Studio-2015 using Access Table in Back end. I have receive aforesaid error while inserting record in table.If I use TWO fields i.e. CurrYear & SAP_No, it works fine but when I try to add THIRD field i.e CPF_No, with parameter it shows Error.

What can I do where field names and field sequences in table are same ?

My Codes are as follows:-

What I have tried:

Private Sub BtnSave_Click(sender As Object, e As EventArgs) Handles BtnSave.Click
        '********************************************************************************************

        BtnSave.Enabled = False

        Dbconnection.Close()

        Dbconnection.Open()

        'AddEmpCmd.CommandType = CommandType.Text

        AddEmpCmd.CommandText = "INSERT INTO EMP_MASTER " &
             "(CurrYear, Sap_No, CPF_No) " &
             "VALUES (@CurrYear, @Sap_No, @CPF_No) ; "



        Try
            ' AddEmpCmd.Parameters.AddWithValue("@CurrYear", CmbYear.Text.ToString())
            'AddEmpCmd.Parameters.AddWithValue("@Sap_No", TxtSapID.Text.ToString())
            'AddEmpCmd.Parameters.AddWithValue("@CPF_No", TxtCPFNo.Text.ToString())
            

            AddEmpCmd.ExecuteNonQuery()
            Dbconnection.Close()

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try


    End Sub