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.