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.

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.


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