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

 

[Pat Hartman]

Requery does what it says. It requeries the RecordSource. That implies that it will automatically reposition to the beginning of the recordset.

You will find that performing the calculations in your queries will eliminate most of the form issues that you are facing. When the calculations are performed in the query, Access takes care of recalculating them automatically when an underlying field value changes.

 

[Rats]

Thanks Pat

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

Peter