Unanswered: using find and replace window to search values
I have a command that opens the find and replace window, by default the 'Look in' box is the active control, therefore if I click on the 'Company Name' box the find and replace will search in this field. However, I have the option to replace the active control in the 'Look in' box for the form name which then allows the user to search in all the controls in the form. I want to be able to have the form name as the default at all times regardless of which control is active in the find and replace window allowing the user to find and replace in all fields on this form, how can this be achieved?...I have placed the vbcode for the command below...
Private Sub cmdsearchIndex_Click()
On Error GoTo Err_cmdsearchIndex_Click