Multi Part Binding Source filters

SchoolTeacher54
SchoolTeacher54 used Ask the Experts™
on
Hello,

I have a two part Boolean based filter that I need to apply.  Seemingly I have run every combination except for one. The 'one' part is where I need help! I've included one version of what I've tried bellow to give the idea of what I need to do.

Email: a field from a bound table
POC_email: a field from a bound table
CompanySearch.is a text box that the user enter their needed terms (e.g. 'Edward')

The concept is that I would like to return all record where the field data includes the search term indicated in 'companysearch.text'

Sample non working code:
Master_ContactsBindingSource.Filter = "email like '" & CompanySearch.Text & "*'" Or "POC_email like '" & CompanySearch.Text & "*'"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
Maybe try with a valid SQL-esqe clause:

Master_ContactsBindingSource.Filter = "email like '" & CompanySearch.Text & "*' Or POC_email like '" & CompanySearch.Text & "*'"
SchoolTeacher54

Author

Commented:
Scott,

SQL-esqe is good! I appreciate the straightforward answer .
Perfect!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial