Question

Locked

MS Access - Form with subforms.

By plemarr ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

try this

by unhappyuser In reply to MS Access - Form with sub ...

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

Collapse -

Instead of OnUpdate

by Maevinn In reply to try this

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.

Related Discussions

Related Forums