I have a form that my user inputs a company name, based on that name I want to populate another field (ContactName) in a related table.
The company names are endless and are added to monthly however the contact names are organized by a range of Client Names. Here is the data.
Client Names A – CE
Client Names CF – GZ
Client Names H - NE
So If the user enters the client name of Happy Place, I want to populate a table called AAA Customers with "Blonde_tipton@aaa.com.
Is there a way in an IIF satement to evaluate a text string by saying "starts with", like iif Client Begins with H - NE????