I have a form with a continous subform. the main form has a refresh button, which builds an SQL SELECT based on criteria and does mySubForm.Requery
Whenever refresh is hit, my client complains that his cursor "jumps" to the first row and wonders if it can remain on the same row.
This "jump" is obviously caused by .Requery, but I'm wondering is there a way that i can findout wwhich control had last focus and the recID, then set focus back after Requery?
Private sub txt_GotFocus 'on subform
mainFRM.txtRow = me.ID
mainFRM.txtControl = "txt"
private sub cmdRefresh.'on main forn
mySubForm.RecordSet = strSQL
mySubForm.row.setfocus = me.txtRow '???
i guess, all i need is how can i choose the row (line marked by ???), and of course, if the above can be more sufficient