I have a few fields in a form and I'm using the after update event. A calculation of the three fields takes place after an update is made in any of the three fields and places the total in a fourth field. I've also used the refresh and repaint method after the calculation takes place. However, if I'm on, say record 5, after the update, it takes me back to the first record. I need to stay on the current record, not go back to the first record. Any tips in how to fix this?

ghall202,

Can I ask why exactly are you using the Refresh AND Repaint methods?

If it is to update the screen, then just use the Repaint method, this will redraw the screen and won't move the recordset back to the first record.

Hope this helps,
Rob