J
JamesJ
Trying to return records if the record has data in Email field with the
on the OnClick of a command button:
Dim strSQL As String
strSQL = "SELECT * FROM tblContacts WHERE (Email<>IsNull)"
Me.RecordSource = strSQL
It's not working and I'm getting a headache.
Any help will be appreciated,
James
on the OnClick of a command button:
Dim strSQL As String
strSQL = "SELECT * FROM tblContacts WHERE (Email<>IsNull)"
Me.RecordSource = strSQL
It's not working and I'm getting a headache.
Any help will be appreciated,
James