ACC2: Find Record Wizard Command Button Has Options Disabled

RESOLUTION

   Screen.PreviousControl.SetFocus
				

1. Open the form containing the command button in Design view.
2. Use the right mouse button to click the command button that you created with the Command Button Wizard, and then choose Build Event from the menu that appears.
3. Add the following line as the second line of code in the module:
   

         Screen.PreviousControl.SetFocus
   						

   
   After you add the line, the code should be similar to the following sample code:
   

         Sub ButtonX_Click ()
            Screen.PreviousControl.SetFocus
         On Error GoTo Err_ButtonX_Click
   
            DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 10, , A_MENU_VER20
   
         Exit_ButtonX_Click:
             Exit Sub
   
         Err_ButtonX_Click:
             MsgBox Error$
             Resume Exit_ButtonX_Click
   
         End Sub
   						

4. Save the form.