How do I disable a form tab using VB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nitestalkernet - 26 Sep 2006 05:39 GMT

On a form with tabs, Tab1 and Tab2, with both enabled for editing.

If I set a value from 1 to 2 somewhere, how do I get Tab2 to disable to read
only state? It is set to open the form from a VB command.

Reply to this Message

Rick Brandt - 26 Sep 2006 12:22 GMT

> On a form with tabs, Tab1 and Tab2, with both enabled for editing.
>
> If I set a value from 1 to 2 somewhere, how do I get Tab2 to disable
> to read only state? It is set to open the form from a VB command.

If you set the Enabled property of the Tab Page to No (false) then all controls
on the page will be disabled.

If you prefer Locked to Disabled then you would have to loop through all the
controls on the Tab Page instead.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message