How do I set the default field when opening a form in Access?

  • Thread starter Thread starter Rebecca1121
  • Start date Start date
R

Rebecca1121

I have created a form (which also contains a sub-form), and I would like the
cursor to default to a specific field. How am I able to do this?

I have been able to set the tab order, so that the first field in the
sub-form is the default cursor position when opening the form. However, when
I arrange the tab order of the sub-form (to make the 3rd field the default
opening position), Access rearranges my columns in the sub-form to match the
tab order! I want the original tab order, but I want the 3rd field to be the
location of the cursor when the form opens.

Thanks!
 
Rebecca

In the form's OnOpen event, add something like (untested):

Me!YourStartingControl.SetFocus

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top