referencing a page on tab control

[stumpy]

This may seem an easy question but how do I open a form,opening it on a
perticular tab. Ive got as far as:-

Dim stdocName As String
Dim stLinkCriteria As String
stDocname="ArchiveForms"
DoCmd.OpenForm stdocName,,,stLinkCriteria

On the form I have Tabctl1 with pages 1,2,3,I am trying to open the form
onto page2 to show list1

Any help is greatly appreciated

 

[Stuart McCall]

This may seem an easy question but how do I open a form,opening it on a
perticular tab. Ive got as far as:-

Dim stdocName As String
Dim stLinkCriteria As String
stDocname="ArchiveForms"
DoCmd.OpenForm stdocName,,,stLinkCriteria

On the form I have Tabctl1 with pages 1,2,3,I am trying to open the form
onto page2 to show list1

Any help is greatly appreciated

Setting focus to the first item in a page's tab order will display that
page, so:

Forms(stdocName)!list1.SetFocus

ought to do it.

 

[stumpy]

Thanks Stuart,works a treat

Setting focus to the first item in a page's tab order will display that
page, so:

Forms(stdocName)!list1.SetFocus

ought to do it.