Go to the first record in subform

[Guest]

I have a main form with a subform. In the main form I have a textbox that
when I type in it the subform will requery selecting the items based on the
text entered in the textbox. The subform allows additions: I dont think
this has anything to do with my issue, I am mentioning it just in case. My
issue is that when I type in the textbox on the mainform and the subform is
requeried the current record on the subform is not always the first record
and as a result the first record of the subform sometimes does not even show
and I have to vertical scroll to see it. How do I make the subform always be
on the first record after the subform is requeried.

Thank you for your help.

Steven

 

[tina]

hmm, that sounds strange. normally after you requery a form (or a subform
object) the focus falls on the first record in the "new" recordset, unless
there is some code somewhere that directs focus to another record. suggest
you check your VBA for code that may be running after the subform requeries;
try putting a break on the "requery" code, and stepping through it.

hth