How to populate a Sub-Form textboxs

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.
 
J

Jeff L

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!
 
D

Douglas J Steele

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)
 
Top