Opening form and going to specific page tab

[Johnny Drama]

Hi all,

I'm trying to create a button that when click will open a form and go to the hoursentry_page tab, but I can't seem to get the code working.

Does anyone have any idea how this could be done and could you provide an example?

Thanks in advance.

 

[River34]

Try using this on the form's open event:

DoCmd.OpenForm "YourFormName"
Forms![YourFormName].TabCtl104.Value = 1


Only you know the TabCtl(yourtablname) (check the name on the properties sheet)

You can then determine if it's = to 1, or 2 or 3, depending on what tab you want to see when it opens.

Good luck!