Is there a way when a form is opened that the Find Record box opens up on a field I want?
K Kevin Sebring Apr 24, 2007 #1 Is there a way when a form is opened that the Find Record box opens up on a field I want?
S Sprinks Apr 24, 2007 #2 Kevin, In the On Open event of the form: Me![YourLookupField].SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 Sprinks
Kevin, In the On Open event of the form: Me![YourLookupField].SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 Sprinks
