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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
VB6 Component Issue with TDBGRID 0
Access Sub form opens before the main form in MS Access 0
Creating a coded event on a sub form 3
Problem referring to a subform control from a query 5
Change Subform within Subform record source proptery to paramter query 2
How do I use a class property as criteria in an Access query? 2
Call Stored Append Query 3

Back
Top