running a requery

[fatboy95]

I have a subform that is continous. Several of my text boxes on the subform do sorting. On the afterupdate function I have docmd.requery. This works fine except it changes focus on the subform to the first record. Is there anyway of stopping this?

Thanks

 

[Pat Hartman]

No. Requery does just what it sounds like. It reruns the query. Since you are resorting the recordset, what is the problem with repositioning to the beginning? I would think that that would be the desired behaviour.

 

[fatboy95]

The problem with it is I have several textbox's and when I run the requery it goes back to the first textbox. I have to tab back through all my textbox's.

I figured out a way of making it work tho. I just made a button to run the requery with. I think that will work out better.

 

[Rich]

Use the FindRecord method