Hi everyone,
My goal is to make a search bar in a split form. For now, I want to keep it simple and have the datasheet filter by organization/agency name. Here's the query I have so far:
I tried typing it out in the search bar but nothing comes up. Thoughts?
Thank you!
My goal is to make a search bar in a split form. For now, I want to keep it simple and have the datasheet filter by organization/agency name. Here's the query I have so far:
Code:
SELECT AgencyINFO.[Organization Entity/Agency Name(Legal Name)], AgencyINFO.[Subsidary Name], AgencyINFO.[Expiry Date], AgencyINFO.[Insurance Expiry Date], AgencyINFO.[WSIB Employer Declaration Complete?], AgencyINFO.Prov, AgencyINFO.[Postal Code], AgencyINFO.[Contact Name], AgencyINFO.Position, AgencyINFO.Email, AgencyINFO.[Phone/Extension], AgencyINFO.[Program(s)], AgencyINFO.Address, AgencyINFO.Prov, AgencyINFO.City
FROM AgencyINFO
WHERE [Organization Entity/Agency Name(Legal Name)] LIKE "*" & Forms!splitAgencySearch!SrchText & "*"
I tried typing it out in the search bar but nothing comes up. Thoughts?
Thank you!