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

[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!

 

[Jeff Boyce]

Rebecca

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

Me!YourStartingControl.SetFocus

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP