How to populate a Sub-Form textboxs

  • Thread starter Thread starter Brandon Johnson
  • Start date Start date
B

Brandon Johnson

Does anyone know how to populate a subforms textboxes from some certain
criteria initiated in the parent form. I have a DAO.Recordset so i want
to tie that into the sub form to. Please if anyone can help please do.
thankyou.
 
To refer to a field on a subform, the syntax is
Forms!MainFormName!SubformName!FieldName. Use that syntax to set your
values on the subform. Hope that helps!
 
I don't believe that's correct, Jeff.

AFAIK, it should be Forms!MainFormName!SubformControlName.Form!FieldName

Note that the SubformControlName may or may not be the same as the name of
the form being used as a subform. If you created the form/subform setup by
dragging form A on top of form B, then the subform control will likely be
named the same as the form. However, if you added a subform container to the
main form and then provided the information required for it, the subform
container will likely be named something like Child0 (where the digit will
vary)
 
Back
Top