I have a split-form where I am attempting to set up a search. I currently have the search set up to search the SSN field, the FirstName field, and the LastName field... Unfortunately there is a limit to how long this string can be. Is there a way to set up a combo for First Name and Last Name... so if someone searches for Joe Blow it will fine the one that matches both fields, but if they only search for Blow it will search for just that name in either field? I would also like a way to search for first letter of last name and last 4 of ssn, so A1234 if possible. Current code below:
Code:
[SSN] Like "*" & Replace([Forms]![frmRecordsSearch]![SearchFieldTxt],"-","") & "*" Or [LastName] Like "*" & [Forms]![frmRecordsSearch]![SearchFieldTxt] & "*" Or [FirstName] Like "*" & [Forms]![frmRecordsSearch]![SearchFieldTxt] & "*"