Bound

[Guest]

I have a Project Information form that houses 5 subforms, I can I bound or
link those forms to my master table? Everytime I enter new information, I
want to be able to see it in my master table. Thanks.

 

[John Vinson]

I have a Project Information form that houses 5 subforms, I can I bound or
link those forms to my master table? Everytime I enter new information, I
want to be able to see it in my master table. Thanks.

You can bound a subform to a table, yes; but ordinarily the main form
would be bound to a master table, and each subform to a related table.
You would NOT store data from the related tables redundantly in your
main table; instead, you would create a Query linking the tables
together.

What are the Recordsources of the main form, and the subforms? Is the
data you enter being lost, or stored correctly in the "child" tables?
Remember - a Form is *not* a data storage medium; it's a window which
views the data stored in tables, so you're not "entering data into the
form", you're using the Form as a tool to enter data into tables!

John W. Vinson[MVP]