im working on an enployee directory where im having issues searching the Hobbies field for a requested hobbie.
My Table named EmployeeInformation contains a short text field named Hobbies among others.
my isssue is with the hobbie field.
So, people are entering tings like "fishing, Biking, Boating" in to the hobie field
Basically they are entering multple words in this field. I am trying to figure out how to open a form where they can enter a word into a text box and find any record that has that word anyplace in the hobbies field,
So this is what I have
I have s form named Employee Directory that im using as a way to filter another form named Employee information list so that it only shows desired records.
The Employee Directory form has a Text Field currently named Text1, and several command buttons on it like Hobbies that when clicked should open the Employee Information List form based on what is in the Text1.
My Problem
If i enter the word Fishing in the field Text1, and click on the hobby button it wont bring anying because Fishing may only be one of several words in a records Hobbies Field.
Im assuming this is an easy "contains" statement of some type but im not getting it.
Can you Help?
Thanks
Dave