Move from one page to another on a tab control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ernie - 12 Mar 2007 20:11 GMT

I've just tried samples from about 6 different posts and have been
unable to solve this. Quite simply (and I know it must be), I have a
tab control (Name=TabCtl36) with 6 pages on it. On Page 2 (Page Index
1) I have a field STOCK. When someone enters text in the STOCK
field, I want the After Update event of the STOCK field to set the
focus to the DESCRIPTION field on Page 3 (Page Index 2).

Can someone help me with the syntax (please be exact using field/tab
names above). Thanks.

Reply to this Message

Peter Hibbs - 12 Mar 2007 23:22 GMT

Ernie

Try

Private Sub STOCK_AfterUpdate()
Me!DESCRIPTION.SetFocus
End Sub

HTH

Peter Hibbs

>I've just tried samples from about 6 different posts and have been
>unable to solve this. Quite simply (and I know it must be), I have a
[quoted text clipped - 5 lines]
>Can someone help me with the syntax (please be exact using field/tab
>names above). Thanks.

Reply to this Message

missinglinq - 13 Mar 2007 01:18 GMT

As Peter has intimated, controls on Tabbed Pages are, in fact, simply
controls on the same single form, which is to say that you reference them as
if they were on a single "screen." There is no need to refer to the Tabbed
Page's name or index.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message