S
Scafidel
I have seen a lot on this, but I simply can't seem to apply it to my
database. I would like to add a subform to an Access 2007 form that I use to
merge (using bookmarks) to a document in Word. Producing this word document
and keeping a record of the associated information is the main function of
the database. I would like to simplify the database by adding tables to the
huge one I now have. I set up another table with information I would like to
add, a junction table, did relationships and a query that makes the subform,
all of which work fine.
I would like to have the second, third, etc of the recordsets of the subform
also show up in individual text boxes on the form, so I can complete the
merge. The Recordset includes a Clause Field that might be as many as five
or six records. Textbox1 source would be Clause Field and the first one does
show up.
But how do I get the other records, Clause(s) to appear on the form in
Textbox2, Textbox3, etc?
database. I would like to add a subform to an Access 2007 form that I use to
merge (using bookmarks) to a document in Word. Producing this word document
and keeping a record of the associated information is the main function of
the database. I would like to simplify the database by adding tables to the
huge one I now have. I set up another table with information I would like to
add, a junction table, did relationships and a query that makes the subform,
all of which work fine.
I would like to have the second, third, etc of the recordsets of the subform
also show up in individual text boxes on the form, so I can complete the
merge. The Recordset includes a Clause Field that might be as many as five
or six records. Textbox1 source would be Clause Field and the first one does
show up.
But how do I get the other records, Clause(s) to appear on the form in
Textbox2, Textbox3, etc?