Set Focus to specific tab in tab form from another form

[Kim]

Hi,
I have looked for an answer, but the only answerI have found is in
conjection to another question. My knowledge is limited and I could not pull
the code I need.

I have a form. It has a label. I would like to click on the label and have
the user be directed to a page in another form with tabs. for example, they
go to page 1, the second tab in the form, which has the name of SpecialOps.
Am I using the wrong control. Should it be a command button.

Should I use VB or should I create a macro.
I have tried both. I have looked everywhere. Although I have seen code, none
of it works.
I tried
[Me].[TabCtMS].[Pages](1).[SetFocus] and several variations.
tab form name - QBF_Form
tab name - SpecOps or index 1

Than kyou.
Kim

 

[Stuart McCall]

Hi,
I have looked for an answer, but the only answerI have found is in
conjection to another question. My knowledge is limited and I could not
pull
the code I need.

I have a form. It has a label. I would like to click on the label and have
the user be directed to a page in another form with tabs. for example,
they
go to page 1, the second tab in the form, which has the name of
SpecialOps.
Am I using the wrong control. Should it be a command button.

Should I use VB or should I create a macro.
I have tried both. I have looked everywhere. Although I have seen code,
none
of it works.
I tried
[Me].[TabCtMS].[Pages](1).[SetFocus] and several variations.
tab form name - QBF_Form
tab name - SpecOps or index 1

Than kyou.
Kim

All you have to do is first open the form, then set the input focus to the
first control in the required page. If the control is called MyControl,
then:

DoCmd.OpenForm "MyFormName"
Forms!MyFormName!MyControl.SetFocus

 

[Kim]

Thank you very much.
I was so confused I had every piece of code I'd see all jumbled up together.
It worked and I was able to set up all of the other tabs. Thank you again.
Kim

Hi,
I have looked for an answer, but the only answerI have found is in
conjection to another question. My knowledge is limited and I could not
pull
the code I need.

I have a form. It has a label. I would like to click on the label and have
the user be directed to a page in another form with tabs. for example,
they
go to page 1, the second tab in the form, which has the name of
SpecialOps.
Am I using the wrong control. Should it be a command button.

Should I use VB or should I create a macro.
I have tried both. I have looked everywhere. Although I have seen code,
none
of it works.
I tried
[Me].[TabCtMS].[Pages](1).[SetFocus] and several variations.
tab form name - QBF_Form
tab name - SpecOps or index 1

Than kyou.
Kim

All you have to do is first open the form, then set the input focus to the
first control in the required page. If the control is called MyControl,
then:

DoCmd.OpenForm "MyFormName"
Forms!MyFormName!MyControl.SetFocus