Link to home
Start Free TrialLog in
Avatar of SchoolTeacher54
SchoolTeacher54

asked on

Multi Part Binding Source filters

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 & "*'"
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SchoolTeacher54
SchoolTeacher54

ASKER

Scott,

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