Button to open certain tab

[LukeJ Innov]

Hi All,



Basically pretty sure it's a simple command but struggling to figure this one out.

I have a form with a two page tab control on it, on another form I have a button, I would like that button to open the form (easy 'docmd.openform,,"frmname") but also to show a certain page of the tab control.

Cheers,

LJ

[orange]

You may want to review your DoCmd.OpenForm syntax
Here's a link
http://msdn.microsoft.com/en-us/libr.../ff820845.aspx

[Missinglinq]

You can do that using the OpenArgs argument of the DoCmd.OpenForm command, similar to opening the Form to a given Record, except that this time you're simply passing a message to Access, telling it to open the given page:

In the first Form (replacing FormToBeOpened, of course, with the actual form name)

DoCmd.OpenForm "FormToBeOpened", , , , , , "OpenTabPage"

Then, in the Form to be opened:

Private Sub Form_Load()

If Len(Nz(Me.OpenArgs, "")) > 0 Then
 
 If Me.OpenArgs = "OpenTabPage" Then
   Me.TabControlName.Value = X
 End If

End If

End Sub

Replace TabControlName with your actual Tabbed Control name, and the X with the page index number of the page you want opened. The index is Zero-based, so the first page = 0, the second page = 1, etc.

Linq ;0)>