Share via

set focus on subform

Anonymous
2019-02-10T08:50:42+00:00

Any ideas please

I have a combo box, after update I want the focus to be on a field within a continuous subform

after update on the main form im using 

Me.frmSubstatus.SetFocus

but when I have updated the combo box I get a error , compile error method or data not found

Any help is appreciated

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2019-02-10T10:48:26+00:00

Yes, you should use

Me.Child610.SetFocus

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2019-02-10T09:22:42+00:00

Make sure that you use the name of the subform as a control on the main form; this is not necessarily the name of the subform in the navigation pane.

To find the name you need to use, open the main form in design view. Click once on the subform (don't click on it again, for then you will select something on the subform). Then look at the Property Sheet.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-10T12:43:16+00:00

    Thankyou

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-02-10T09:35:47+00:00

    thanks Hans

    Its says

    Name:Child610

    Sourceobject is :frmSubstatus

    would I have to use the child 610?

    Was this answer helpful?

    0 comments