i have a form with a subform inside, the subform requeries after the user changes some controls in the main form, but a problem is that ofthen the user leaves the subform, lets say, in record #10, and when it requeries the subform sets itself in record #10 (of the second recordset), i would like to know a way to position the subform on the first record after a requery, and be able to position it on any arbitrary record i want

i would ve very glad for your help

thanks for your advise