Going to top-of-form via navigation keys

[cjp-cbc]

I'm very new to Access and trying to troubleshoot a long form developed by
others. The problem: when using the navigation keys to advance to the next
record, the next record appears with the focus halfway down the form instead
of at the top. The tab order appears to be correct. What can be done to
correct this? Thanks to all.

 

[Beetle]

Set the focus back to the first control (text box, etc.) in the form's
Current event;

Private Sub Form_Current

Me![SomeControl].SetFocus

End Sub


Having said that, it sounds like redesigning the form using a tab control,
or separating it into multiple forms might be in order. It doesn't sound
very user friendly if you have to do a lot of scrolling up and down.