Referencing a Field or text box...

[doran_doran]

I have a field on a Subform and that subform has 4 tabs.

I just want to reference one field call chkCensusRequired from this subform.

All I want to do on my main form is to read a check box thats on a subform's tab.

HELP PLEEEEEAAAASSSSSEEEEEEE


chkCensusRequired is a check box in the my subform (form name: frmBasicCase) (subform name: subform BasicCase) (tab name: tabServicesandFees)

If [Forms]![frmgroups]![Subform BasicCase]![tabServicesandFees].Form![CensusRequired] = True Then
Me![Census_Mailed].Enabled = True
Me![Census_due_date].Enabled = True
Me![1st_rcvd].Enabled = True
Else
Me![Census_Mailed].Enabled = True
Me![Census_due_date].Enabled = True
Me![1st_rcvd].Enabled = True
End If



=== more background = = =
The Main form is "frmGroups"
The Sub form is "frmBasicCase", name for this under frmgroups is Subform BasicCase
There are five(5) tabs in the frmBasicCase (the subform)
1. tabMoreInfo
2. tabServicesandFees
3. PageFunds
4. PagerOthers
5. Partic Rates

 

[KenHigg]

If [Forms]![frmgroups]![Subform BasicCase].Form![CensusRequired] = True


???
ken

 

[doran_doran]

hmm, that did not work...

If [Forms]![frmgroups]![Subform BasicCase].Form![CensusRequired] = True

I tried above code and it did not work. There is a tab under subform basiccase and it's called tabservicesandfees. I am lost.................

 

[KenHigg]

Basiclly, just forget having to ref any of the tab stuff.

Is the name of the control on the subform 'CensusRequired' or 'chkCensusRequired'?

And, what is the name of the subform as it shows up as a control property on the mainform?

kh

 

[doran_doran]

reply

chkCensusRequired is the name of the subforms > tab > check box name

 

[KenHigg]

[Forms]![frmgroups]![Subform BasicCase].Form![chkCensusRequired]

kh