View Full Version : Referencing a subform on a tab


echorley
02-24-2009, 10:12 AM
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
02-24-2009, 10:20 AM
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/QuickTutorials/Easywaytorememberhowtoreferencesubforms/tabid/76/Default.aspx
and
http://www.btabdevelopment.com/main/QuickTutorials/Easywaytorememberhowtoreferencesubforms/Refertosubformsincontrolsources/tabid/106/Default.aspx

apr pillai
02-24-2009, 10:24 AM
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
02-24-2009, 10:30 AM
Thanks! I was using the name of the object on the tab, and not the name of the subform.

Thanks much.