When i use this code, it finds records all over the main form (RacesetupXCF) and subform (RacetimingSF), instead of focusing only on the racenumber field in this specific subform.
Expand|Select|Wrap|Line Numbers
- [Forms]![RaceSetupXCF]![RaceTimingSF]![RaceNumber].SetFocus
- DoCmd.GoToControl Screen.PreviousControl.Name
- Err.clear
- DoCmd.RunCommand acCmdFind
Expand|Select|Wrap|Line Numbers
- [Forms]![racesetupxcf]![RaceTimingSF]![RaceNumber].SetFocus
- SendKeys "%ha%n", False
- DoCmd.RunCommand acCmdFind
The "Look in " option is "greyed out"
please assist