Referencing a subform on a tab

[echorley]

I am trying to reference a text box on a subform, that is located on a tab.

The main form is named: Language Arts Assessments
The tab control is named: Ind_Grades
The Individual tab is named: Kindergarten
The subform on the tab is named: Kindergarten1
The textbox is named: Wi_DRA2

Do I need to include all 5 levels in the Query criteria?

 

[boblarson]

Ignore the tabs (tabs act like they don't exist when referring to forms and items on the tabs).

To refer to a text box on the subform (provided the subform CONTAINER CONTROL, the control on the main form that houses the subform - not the subform itself - is named Kindergarten1) would in a query be:

[Forms]![Language Arts Assessments]![Kindergarten1]![Form].[Wi_DRA2]

See here for more about subforms and the syntax and the control:
http://www.btabdevelopment.com/main...rhowtoreferencesubforms/tabid/76/Default.aspx
and
http://www.btabdevelopment.com/main...bformsincontrolsources/tabid/106/Default.aspx

 

[apr pillai]

FORMS![Language Arts Assessments]![Kindergarten1].Form![Wi_DRA2]

You don't have to address the Tab-Control to reference the Text Box on the Sub-form.

 

[echorley]

Thanks! I was using the name of the object on the tab, and not the name of the subform.

Thanks much.