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?