making a more useful Find

[ifoundgoldbug]

Greetings once again

Is there some way to customize the find and replace window? basically
what I would like is to have the look in drop down box to be populated
by all the fields on my Form. Is this possible?
IE have look in work order #, tool no, part no. ect. instead of look
in work order and entire table.

 

[Al Camp]

Have you tried the built in feature FilterByForm. That allows filtering on any field
in the recordset. (Filter, not Find)
Bring up FilterByForm, enter those criteria value/s in the field/s, run the filter, do
your thing with the records, and then Remove Filter Sort will put you back to All records
again.

On my website, (below) I have a sample file (A97 and A2003) called QuickFindCombo that
shows how to use a combo box to quickly access any record in the recordset by a single key
value.
This is usually set to the most often used field to find a record.
On some forms I may have one more QuickFindCombo for another "popular" field to search
on, but I usually don't have any more than 2 on any one form.