referencing a page on tab control

  • Thread starter Thread starter stumpy
  • Start date Start date
S

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
 
stumpy said:
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
Click to expand...

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.
 
Thanks Stuart,works a treat

Stuart McCall said:
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.
Click to expand...
 
Back
Top