after a user enters a bit of data, i'm trying to see if the data already exists in the field. i have built the SQL on the fly for my queries and got it to work with check boxes and exact string matches, but am having trouble getting portions of strings to match.
example: user inputs L Rear
and say the entry field is called txt_entry
if i already have a record with R Rear, I want the L Rear to query it out. I know that if the user enters Rear, i can use a combination of
Like "*" & Forms!Sample.txt_entry & "*"
to get a match. is there any way to have a match occur when any of the words in an entered field match the value of an existing record?