SetFocus Tab Control

[Ashley]

Using Access 2002, I have a form with a Tab Control that
has 4 pages.

What I want to do is that when data in entered into a
text box on Page 4 focus is set to a text box on Page 1.

Using Me!TabCtl0.Pages!Details.SetFocus moves focus from
Page 4 to Page 1 but trying to go to the Type contraol on
Page 1 using Me!TabCtl0.Pages!Details!Type.SetFocus I get
a message Run time error 428 Object doesn't support this
property or method"

Advice on where the code is wrong would be appreciated

Thanks in advance

Ashley

 

[Allen Browne]

In the AfterUpdate event procedure of the text box on page 4, you should be
able to just SetFocus to the text box on page 1, e.g.:
Me.Text1.SetFocus

 

[MacDermott]

Type is a reserved word in Access -
you may have better results if you use something like MyType,
ProductType, or whatever fits your situation.