Referring to control on a Sub-form

  • Thread starter Thread starter JimP
  • Start date Start date
JimP said:
How do I refer to a control on a sub-form in the query grid?
Click to expand...

Assuming a sub-form only one level deep...

Forms!Tom!Dick.Form!Harry

....where...

Tom = Name of the parent form
Dick = Name of SubForm control **
Harry = Name of control on the child form

** Note that the actual name of the child form is not included in the above
syntax. This is a common source of confusion. In many cases the name of the
SubForm control on the parent form is identical to the name of the child form it
displays, but that is coincidental and not always the case. It is the name of
the SubForm control that must be used followed by the dot-Form shown.
 
Back
Top