Select same record in subform after reorder

[Never Hide]

I have a subform inside a form and in this subform I have an Ordering field which orders the items in the form based on this field. In the After Update event of this box I use Me.Requery so that you can actually see the change of the order in the items. The problem is that after requering the form the selector goes to the first item of the form.

Is it possible some way to keep the selector to the same item after the requery takes place?

 

[pbaldy]

Try

http://www.baldyweb.com/Requery.htm