Open Form To Specific Tab

[shoelesscraig]

I have a report that has a button on each row, where if you click the button it will open a report (called "Project Proposal Summary") and go to the corresponding record ID based upon which button you clicked. The code is the following:



Private Sub GoToRecButton_Click()


DoCmd.OpenForm "Project Proposal Summary", , , "ID = " & Me.ID


End Sub



Works great, but I'd like to add one thing if possible and I don't know how to do it. The form that it opens has multiple tabs on it. Currently it just opens the form and shows the default 1st tab, but I'd really love it if it opened the form and went to my second tab, which is called "ActionItemsPage". This tab has a page index of 1. I'm thinking there is some code I could add that would make it open to that tab, but I have no idea what it would be. Keep in mind, I only want it to automatically go to this tab when I click the buttons on that particular report. If I just open that form normally, I want it to just open the default tab as it does now. Anybody have an idea?

[ranman256]

in the ON LOAD form event,
TabCtl.Value = 2 (or the needed tab#)

and FYI, you dont need a button on every row, a single button in the form header will do the same thing, with the same code.
it uses the record the cursor is on, and is not as busy with hundreds of buttons.

[shoelesscraig]

in the ON LOAD form event,
TabCtl.Value = 2 (or the needed tab#)

and FYI, you dont need a button on every row, a single button in the form header will do the same thing, with the same code.
it uses the record the cursor is on, and is not as busy with hundreds of buttons.

I'm willing to try this, no problem. But won't this make that tab open every time, regardless of where it's opened from? I only want that to happen when opened with said button on the report.

[June7]

Will not work if report is in Preview, only Report view. Put code in the button Click event. Options:

1. pass a value to the form using OpenArgs

DoCmd.OpenForm "formname", , , , , , "2"

and code in the form OnLoad event uses as criteria in a conditional statement

If Me.OpenArgs = "2" Then TabCtl.Value = 2

2. use full form name reference
Forms!formname.TabCtl.Value = 2

[shoelesscraig]

Will not work if report is in Preview, only Report view. Put code in the button Click event. Options:

1. pass a value to the form using OpenArgs

DoCmd.OpenForm "formname", , , , , , "2"

and code in the form OnLoad event uses as criteria in a conditional statement

If Me.OpenArgs = "2" Then TabCtl.Value = 2

2. use full form name reference
Forms!formname.TabCtl.Value = 2

Fantastic! Worked like a charm! Thanks so much...