A complete guide to subforms
Tutorials Shared by the Internet Community
Total Hits - 34099
Total Votes - 114 votes
Vote Up - 54 votes
Vote Down - 60 votes
Domain - www.functionx.com
Category - MS Access/Forms
Submitted By - Shekhar
Submitted on - 2008-04-15 07:21:56
Relational database allows you to separate data in objects so that these objects can hold different pieces of information and make data available to other objects that need it. Sooner or later, users constantly need information held by one form while they are working on another form. There are various ways you can solve such a problem. One solution is to "embed" one form or report into another form or report.
A subform is a form that you position inside of another form. In order to "include" one form into another form, both objects must have a relationship, as we have learned in the past. The form that is hosting the other form is the parent. The form that is added to the parent is called the child form. The parent form must have a primary key that "links" or relates it to a foreign key in the child form. This foreign key of the child object must be of the same data type as the primary key on the parent object. More detail...