Trouble adding new record to Access DB

[Rick LV]

I keep getting "Compile Error - Method or data member not found" for .AddNew in my code. What am I doing wrong here?

Dim sql As String
adcPayroll.CommandType = adCmdText
sql = "SELECT * FROM Employees_pay"
adcPayroll.RecordSource = sql
adcPayroll.Refresh
adcPayroll.AddNew
    adcPayroll!FirstName = txtFirstName.Text
    adcPayroll!LastName = txtLastName.Text
    adcPayroll!DepartmentName = cmbDepartment.Text
    adcPayroll!Shift = lstShift.Text
    adcPayroll!SocialSecurityNumber = mskID.Text
    adcPayroll!Salary = txtSalary.Text
    adcPayroll!PayrollEndingDate = mskDate.Text
    adcPayroll!Dependents = lstDependents.Text
    adcPayroll!HoursWorked = txtHours.Text
    adcPayroll!Shift = lstShift.Text
    adcPayroll.Update
End Sub