Open Form Tab

[cktcPeterson]

I have a button to open a form. I want the form to open to a specific tab

I copied this from my macro that opens perfectly.

Form: frmApproveApplication1
View: Form
Where: "[Requested Course.ID]=" & [ID]
Mode: Dialog

I want it to open to tab 2,
Tab name: tbApproveCourse

Thanks for any guidance in this.

 

[tvanstiphout]

I would use OpenArgs argument of DoCmd.OpenForm for that.

You may want to read up on how the NW2 team implemented OpenArgs processing in the Northwind 2 Dev Edition template:

Northwind 2.0 Things You Should Know - Microsoft Support

Northwind for Access Developer Edition guidance

support.microsoft.com

(string functions at 35:30)

 

[theDBguy]

I have a button to open a form. I want the form to open to a specific tab

Are you using a Navigation Form?

 

[Mike Krailo]

In the OnLoad event:

Private Sub Form_Load()
    Me!frmApproveApplication1.Pages("tbApproveCourse").SetFocus
End Sub