I have a subform in datasheet view.
On it I have an AfterUpdate vba sub, which includes a Me.Form.Requery command.
The problem is this makes the cursor jump to the top left field of the table.
I can make it go to the top of the column in question with Me.Quantity.SetFocus
But is it possible to SetFocus to the row that it was in before the Requery?
On it I have an AfterUpdate vba sub, which includes a Me.Form.Requery command.
The problem is this makes the cursor jump to the top left field of the table.
I can make it go to the top of the column in question with Me.Quantity.SetFocus
But is it possible to SetFocus to the row that it was in before the Requery?