How to change Tap Captions based on a control 1

[Quotidius]

My mainForm is a single form that shows each employee. On the detail of mainForm are 5 tabs and each tab contains a unique subform. Each of these subforms has a control called "Core_Description."

Core_Description will vary from employee to employee. How can I set tab1 caption to equal the Core_Description that is contained on Tab1's subform?

Thanks

 

[Remou]

How about:

Me.TabCtl0.Pages(1).Caption = Me.tblTable_subform.Form.Core_Description

 

[Quotidius]

Thanks Remou

Using the OnCurrent Event I tried something like that (found in another thread) but I get the following problem when I open the form:

"Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:
A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base article 283806.
An Expression is misspelled.
Check all expressions used in event properties for correct spelling."

Even changing to a more basic:
Me.TabCtl27.Pages(0).Caption = "test"
yields the same result.

Any Suggestions as to what is causing this problem

 

[Remou]

Just guessing. Are you using the Current event of the main form?

 

[Quotidius]

Yes, Remou, the current event of the main form, the one that has the tabs.

Also here is an addendum to the the last post of mine-the initial form pronouncing my error reads, " A problem occurred while myDB was communicating with the OLE Server or ActiveX Control.

 

[Quotidius]

All is right (the usual operator error). Thanks Remou!

 

[Remou]

Ah, you may have a corrupt form and / or database. Try creating a test form in a new database. If that works, have a look at Decompile in FAQ705-4683.