How to make the cursor go to the first column in the new record row.
Q: Henry W. writes that he needs to move the cursor to the first column in the new record row of a datasheet subform, from the AfterUpdate event of a combo box that assigns a record source to the subform. He has tried using SendKeys, but without success – no error message, but the cursor doesn’t move to the right place.
A: You can make the cursor go to the first column in the new record row using the GoToRecord method of the DoCmd object, after setting the focus on the subform, as in the code listed below:
Me![subResults].SetFocus
DoCmd.GoToRecord record:=acNewRec
Me![subResults]![txtID].SetFocus