Software

Ask something
Question Locked

MS Access - Form with subforms.

0 helpful
3 replies

by plemarr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a form with 2 subforms. After I enter/update a record and tab through the subform fields, the next time I enter the subform the cursor is on the last field. I then have to arrow back through the previous fields on the subform to get to the first field. How can I make it default to the first field of the subform.
Thanks in advance for any help you can give me.
Penny

3 replies

by unhappyuser

Use setfocus for the particular field that you always want to have be first (e.g form_Main.field.setfocus).

Put this in the OnUpdate.

Let me know if you need more help.

EMD

by maevinn

I'd put in on the subform's GotFocus event instead, but that's just me. :)

You can also set the tab order, that should resolve it as well.

This discussion is closed to new replies.