Tab Control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 29 Jan 2005 12:59 GMT

We have an annoying feature on 1 form in a database. The form has a tab
control, with 6 pages, and when we click on a command button to go to next
record on a form we do so but the current tab page goes to Page 5.

Any advice or suggestions as to how, when we go to the next record we remain
on the same tab page

Using Access 2002

TIA
Tom.

Reply to this Message

Rick Brandt - 29 Jan 2005 13:21 GMT

> We have an annoying feature on 1 form in a database. The form has a
> tab control, with 6 pages, and when we click on a command button to
[quoted text clipped - 7 lines]
> TIA
> Tom.

Do you have some code in the current event of the form? This is not normal
behavior.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Tom - 29 Jan 2005 13:41 GMT

Rick

Thanks for the input

The offending line in the current event is:

Forms("Members").Controls("TabCtl28").style = 1

Not sure why this line is there as it is a database that we have taken
over - any suggestions?

Tom

>> We have an annoying feature on 1 form in a database. The form has a
>> tab control, with 6 pages, and when we click on a command button to
[quoted text clipped - 10 lines]
> Do you have some code in the current event of the form? This is not
> normal behavior.

Reply to this Message

Rick Brandt - 29 Jan 2005 13:52 GMT

> Rick
>
[quoted text clipped - 6 lines]
> Not sure why this line is there as it is a database that we have taken
> over - any suggestions?

Remove the line?

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

rkc - 29 Jan 2005 14:15 GMT

> Forms("Members").Controls("TabCtl28").style = 1
>
> Not sure why this line is there as it is a database that we have taken
> over - any suggestions?

The style property of a tab control sets the visual appearance of the
tabs. 1 sets them to buttons. If you don't need/want the appearance of
the tabs to change dynamically then set the style in the controls
property sheet and remove any code that changes it.

Reply to this Message

Van T. Dinh - 30 Jan 2005 03:28 GMT

That line of code doesn't change the Tab page.

Check the CommandButton_Click Event code also. You are looking for a line
of code similar to:

Me.TabControl = 4

or

Me.TabControl.Pages(4).SetFocus

Signature

HTH
Van T. Dinh
MVP (Access)

> Rick
>
[quoted text clipped - 8 lines]
>
> Tom

Reply to this Message