Problem with Subforms in Tab Control

[Erictsang]

Dear Guru

I have made a Tab Control with 3 Tabs in a Form

Profile_frm
then

Accommodaton_Subfrm
Financial -subform
Activities-subform

Have no idea, the subform field are dim and unable to change /amend

Any idea where will went wrong?


Eric

[ranman256]

on the tab OnChange event, set the subform's source

Select Case TabCtl4.Value
  Case "Phones"
     subFrm.SourceObject = "frmPhones"
  Case "clients"
     subFrm.SourceObject = "frmClients"
  Case "Invoices"
     subFrm.SourceObject = "frmInvoices"
End Select

[ssanfu]

Hard to tell what is wrong from your description of the problem. You could post your dB for analysis.......

[orange]

Eric,

You may get some ideas from this youtube video by Dr. V

Good luck

[Missinglinq]

...Have no idea, the subform field are dim and unable to change /amend...

Are the Record Sources of the Subforms based on multi-tables Queries? Many such Queries are Read-Only. Have a look at Allen Browne's excellent article that explains why Multi-Table Queries are frequently Read-Only:

Why is my query read-only?

Linq ;0)>

[Micron]

...Have no idea, the subform field are dim and unable to change /amend...

AFAIK, this has no bearing on whether or not the fields appear "dim". This sounds like a design setting; i.e. the fields of the subform are disabled. If the tab or page is disabled, I still don't think that would dim the controls of the form that is on the page.