What is syntax for displaying a specific tab of a tab control upon an "on open" event of a form?

[jerry.ranch]

I'm starting to learn about the tab control.

How would I write an on open event procedure in VBA, that upon opening
of the form, a specific tab opens (say tab 1)?

Thanks
Jerry

[PC Datasheet]

The pages of a Tab Control are 0 based meaning the first TabPage is page 0.
Add this code to the open event to open to a specific page:

First Tab --- Me!NameOfTabControl.Value = 0
Second Tab --- Me!NameOfTabControl.Value = 1
Third Tab --- Me!NameOfTabControl.Value = 2
etc
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com


<je*********@pioneer.com> wrote in message
news:3d********************************@4ax.com...

I'm starting to learn about the tab control.

How would I write an on open event procedure in VBA, that upon opening
of the form, a specific tab opens (say tab 1)?

Thanks
Jerry

[jerry.ranch]

Yep Thats the syntax
Thanks a bunch
Jerry

First Tab --- Me!NameOfTabControl.Value = 0
Second Tab --- Me!NameOfTabControl.Value = 1
Third Tab --- Me!NameOfTabControl.Value = 2