I am correcting some functionality on a few forms, but I keep getting this error on two of them:
"The expression you entered is the wrong data type for one of your arguments."
I have a subform in the form and need to requery the subform to update the info displayed when i click the 'add to list' button on the form. this is working correctly on two other forms but not these two??? copy and past the code and I just changed the subform name.
Here is the simple code:
Private Sub cmdAddToList_Click()
On Error GoTo Err_cmdAddToList_Click
DoCmd.Requery (frmMemberTypeSubform)
DoCmd.GoToRecord , , acNewRec
Exit_cmdAddToList_Click:
Exit Sub
Err_cmdAddToList_Click:
MsgBox Err.Description
Resume Exit_cmdAddToList_Click
End Sub