I have a form in Access 2007 that uses a parameter query to display a record set. In this case, based on the fields; YEAR and SCHOOL. Each record set will normally display several hundred student records. Within that record set, I need to find students by searching the name field. I will generally have to update multiple records for a particular school, so the name field cannot be part of the forms parameter query.
The FIND command works wells using the any part of the field option, but it has two drawbacks. First, after updating a record, the user has to click back into the NAME field to set the Look in: Otherwise, Look in: defaults to the last field with focus. Second, the FIND dialog box covers much of the form and the user constantly has to move it out of the way.
There will also normally be multiple records with matching names, so there has to be a Next Record function to scroll through the matches.
If I could get the Find Look in: option to remain on the NAME field, even after clicking in a different field on the form; that would work. Obviously, that is not the way the FIND dialog is intended to work.
Filtering is too slow and cumbersome.
I want a way to make the FIND command default and remain looking in the NAME field. Or, a textbox search on the NAME field and the ability to Next Record through the matching subset of records.