Open or enable a tab control

[Nancy]

I have a form with two tab controls and another tab that is a sub form
I want to be able to click on a cmd button on the tab that has a sub form
and show another tab that has data linked to it.

 

[Damon Heron]

You don't need a separate command button, if you are tying selections from
the subform to info you want displayed on the next tab.
I don't know what your subform is, but let's assume its tied to a table. In
the current event of the subform, enter:
Me.Parent.Textbox1 = someSubformField.Value
where Textbox1 is located on the tab page on the main form. That should get
you started so you can tab to that page and view the textbox. The value
could then be used to show whatever data you want to link it to.

Damon

 

[Nancy]

The main form is "client"
Subform is Inventions, could be more than one per client
the other subform is inventor, One per invention
So when I am on the tab and looking at one invention I was the inventor
information displayed for this invention.
On current on the inventor form I tried:
Me.InventionId = Forms!frmClient!fsubInventor.InventionId
Get error: Object doesn't support this object or method

 

[Damon Heron]

It all gets back to the tables you have designed. I don't see a need for a
separate subform for inventors.
I would design tables like this:
tblClient
ClientID
Name
Address, etc.

tblInventions
InventionID
ClientID
InventorName
InventionType, etc.

Then the form would have a source of tblClient, the subform would have
tblInventions with the Master/Child relationship
the ClientID.

Damon