ContactTypeID is in tblContacts, but you are using ContactType ?
I just used the second field in the form as a test?
You will need to use whatever links qryContactDetails to tblContacts?
That is why you get the prompt all the time, as Access does not know of any of those fields.?
I even tried just getting the fileldame and had the same prompt?
Code:
Private Sub cmdSelect_Click()
' DoCmd.RunSQL "UPDATE tblContacts SET EmailSelect = 'Yes' WHERE Me.frmFilterSfrm.Form.Filter"
Dim strsql As String, strFilter As String
Dim iDot As Integer
strFilter = Me.frmFilterSfrm.Form.Filter
strFilter = Replace(strFilter, """", "'")
iDot = InStr(1, strFilter, ".")
strFilter = Mid(strFilter, iDot + 1)
strFilter = Replace(strFilter, ")", "")
strsql = "UPDATE tblContacts SET EmailSelect ='Yes' WHERE " & strFilter
DoCmd.RunSQL strsql
Me.frmFilterSfrm.Requery
End Sub
strFilter was [ContactType]='Agency'
You would need to use the ID for Agency in that control, the same with any other similar type controls?