Requery moves focus to first record

[Rats]

I have a sub form on a tabbed control. In the subform I have some calculated controls and I make them recalc when ever data in other fields change bu entering a recalc cmd in the update event of the required fields. That is all fine but the problem is that the forms focus moves to the first record and I need it to stay on the active record.

I have tried requery, recalc and refresh methods and they all do the same thing.

All I need to do is up date the calculated controls each time a field is updated and stay on the same form but it's eluding me.

Thanks

 

[Rats]

Thanks Pat

I'll redo the form and put the calcs in the query as you suggest. Thanks for that.

Peter