Help opening form to a specific page

[kevinh2320]

In my Access DB I'm trying to open a form called "f-home" to page number 7 with the following code but, it doesn't seem to like the hypen in the form name. I've tried to bracket the form name and put into quotes but can't find the right method.

Private Sub import_rpt_data_Click()

DoCmd.OpenForm "f-home"
Forms!f-home.GoToPage 7

End Sub

Any suggestions?

 

[Joe4]

Usually, you do not refer to Forms in Access by "page" numbers, but rather by "record" numbers.
What exactly are you trying to do?
How is your form structured?

 

[kevinh2320]

On my main form called f-home I've used the control "tab control" and on that control I have multiple pages. On page 7 "Work Area" I have a button that runs some code but, when that code is finished running the form re-opens back to the first page "Letters & Envelopes". When that code finishes running I want the user to be returned to the page they were on "Work Area".

 

[Joe4]

Ah yes, I had forgotten about Tab Controls. It has been many years since I used those.
You have to open the Form, then Set the Focus to that particular page name.
See this example here: Open to specific tab page

 

[kevinh2320]

Nice! That did the trick! Thank you very much!

 

[Joe4]

You are welcome.