Cursor / Focus Problem

[derekmartin]

Hi,

I'm hopiong that someone can help me out with this small problem I am having in access 2003/vba

I have a subform containing continuous records. One of the fields within this form has calculations carrioed out on the afterupdate event. However once this field is updsted and this event hadler is carried out, the focus jumps back to the first record on the form.

I have tried setting the focus, but it only sets the focus to that control on the first record. I need the focus/cursor to remain on the current record.


Any ideas anyone??
Thanks
Derek

[Ecniv]

See if there is a subform refresh being called that doesn't need to be.
Check the tab order of controls?
Don't use a sub form to start with? (use a listbox instead - with a pop up form for data entry/amending)

I don't use subforms, so soory, can't help other than the above checks.