I have looked through many posts and have not seemed to find the solution that is similiar to mine (not saying there isn't one, I just haven't seen it yet). I would like to the user to be able to search a subform for either part# or part description. However, they will probably only know a partial part# or use a generic description to search. I am having trouble figuring out the best course of action to take. I need a way to search any part of the field. Can this be done using RecordsetClone? Should I create a search form seperate and have a onClick to goto the desired record? How do you go about searching with VBA without matching the whole field? I am not looking for someone to devote all of their time to right the example code (the would be rude on my part) but instead looking for some good resources on how to get started so I can learn how to go about this. I hope someone answers this post and many thanks for your time.