I'm creating an 'if' statement and am not sure how to ask for only part of a thread
eg: if Forms![fSHANSHPTSCREEN]![Shipper/Consignee] = shanahan*
open form: abc
where shanahan might be any of the following:
shanahan's manu company
shanahans bldg company
the key is the field will have the string shanahan in it but will have other characters in the string too. I only want the if statement to search for shanahan and ignore anything after it. Can you suggest the proper argument for the if statement?