When using Access 2002 on a form, I have a button that calls up the 'find and replace' dialog box.
If I setfocus to one of the fields on my form, prior to running the code to pull up the dialog box, in Access XP the dialog box sets the 'look in:' to the last field I used. If I want to search all fields on the form, then I need to set the 'look in:' to the name of the table.
Unfortunately sometimes the 'look in:' box comes up disabled.
If I set the focus on a field then it comes up with the field name populated in the 'look in:' box but not necessarily the table name!!!
Any ideas?
Kramerica
If I setfocus to one of the fields on my form, prior to running the code to pull up the dialog box, in Access XP the dialog box sets the 'look in:' to the last field I used. If I want to search all fields on the form, then I need to set the 'look in:' to the name of the table.
Unfortunately sometimes the 'look in:' box comes up disabled.
If I set the focus on a field then it comes up with the field name populated in the 'look in:' box but not necessarily the table name!!!
Any ideas?
Kramerica
