Go to record based on search in Access 2007 form

Hello
I would like to be able to go to a record in an Access 2007 form by searching on partial criteria. For example if I am looking for a business name and it has the word Training anywhere in it's name field I want the form to navigate to that record and then the next record that contains Training. What is the best way to achieve this?

The user presses the "Find Owner" button to enter the partial search term to find the first matching record. To find subsequent records that match the criteria they press the down arrow icon. The code provides the appropriate messages if no match exists or the last match has been reached.

Thanks so much for the reply. I am not a coder so I am attaching the code with my changes the form name is Pay and Benefits and the field name I want to be able to search on is FirstName. Would you be able to look at my code and tell me what is wrong as it's not working?

The only obvious error I could find is that in your DB your initial search is for a string value (First Name) and my code was searching for a number so the variable definition (Dim) for lCurFirstName as Long needs to be changed to zCurFirstName as String. Note that all occurances of lCurFirstName need to be changed to zCurFirstName.

The only other thing is to make sure your buttons are named cmdFindRec and cmdNextFirstName respectively or the events will not fire. HTH