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

 

[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