This finds all the records with e_mail containing the letter "w".
Private Sub no_email_addr_Click() Dim DocName As String
DocName = "frmHomeOwner"
DocFilter = "[e_mail] like '*w*'"
Me.Filter = DocFilter
Me.FilterOn = True
End Sub
but this won't find the email addresses that are null:
Private Sub no_email_addr_Click() Dim DocName As String
DocName = "frmHomeOwner"
DocFilter = "[e_mail] like ''" ' that is a double single quote followed by an ending double quote
Me.Filter = DocFilter
Me.FilterOn = True
End Sub
I get no results and no error messages.
Thgouths on how I can get a list of records where there is no email address?
Thanks,