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)
 

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

Populates 1
SUB Form Population Help. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Populating the data of two Textboxes into One textbox 11
combine records from child into one textbox in parent 2
Populate sub form 1
Access 2 Digit year in Access Text Box 3
Restrict entering Null or Empty in Textbox - Access 2007 0

Back
Top