Help Required again
I need to set focus on a field on the sub form which sits on the main form.I have setup on the sub form that when the form loads this field has the focus.This does not work when it sits as a main form Help needed

Thanks
Brendan

Brendan Bartley

__________________
Brendan Bartley

Brendan,

Do you have any fields on the main form? If you do, the focus will always set to the main form first. If you don't want this to happen, you'll have to set the focus yourself.

Let me know, and I'll tell you how.

Kevin

dartcoach

Yes I need help to do this set focus on the sub form

Brendan Bartley

Brendan,

When you open the main form, you ALWAYS want to set the focus to the subform?

If so, in the on open event of the main form, put:

me.subformname.setfocus

This should set the focus to the subform, which then the field you want to have the focus should have it. If not, change the code to:

me.subformname.subformfieldname.setfocus

Kevin

dartcoach

Brendan,

Sorry, the second code should be:

me.subformname.form.subformfieldname.setfocus

Kevin

dartcoach

Excellent thanks Kevin

Brendan Bartley