Unanswered: The "Look In" field in the Find Repalce Option in Access 2002 sp3
I have a form that I use to look up values in a table. On the form I have a command button that sets the focus to the control field on the form "text20" then opens the "Find and Repalce" screen from Access 2002 sp3.
Private Sub Find_By_Acc_Code_Click()
On Error GoTo Err_Find_By_Acc_Code_Click
Application.SetOption "Default Find/Replace Behavior", 1
Application.SetOption "Move After Enter", 0