Not a problem.
There are two ways to do this.
One is to create a subform control on the main form as size it so it will
show the data you need. The wizard will then allow you to create the form
that will be shown in the subform control.
I prefer to create the form that I will use as the subform first.
Then I create the subform control on the form.
To identify the name of the subform that will show in the subform control is
to enter the name of the form in the Control Source property.
The Link Master Field(s) and Link Child Fields(s) are also properties of the
subform control. These are important and make life much easier.
In the Link Master Field(s) property you enter the field name(s) of the
field(s) in the main form's record source that are the primary key field(s)
of the main form's underlying table. It is usually one field, but can be
multiple fields.
The child tables that relate to the main table need to have a foreign key
field in addition to their own primary key field. That is a field that
carries the value of the primary key field that relates the record to a
record in the parent table. This is the field name you use in the Link Child
Field(s) property.
If you use the Link Master/Child properties, when you create a new record in
a subform, it will autmatically populate the subform's recordset with it's
primary key (if you use an autonumber primary key for the child table) and
will (regardless of whether the child table's primary key is an autonumber)
populate the child table's foreign key field with the primary key value of
the record in the main form. All you need then is to enter the additional
data.
One other hint. When you create a subform control and use the wizard to
create the form to use, it will give the subform control and the subform form
the same name. It is better to give them different names to avoid any
confusion. I use what is sometimes know as Hungarian Notation. That is, a
predefined naming convention where you prefix each object name with specific
value to identify the type of object. For example, All forms start with frm,
forms being used as subforms can do the same or I use subf. Controls on
forms are like txt for Text Box, chk for Check Box, cbo for Combo Box, lst
for List Box, and for a subform control I use sub.
I know this is all probably confusing, but once you do it, the next time
will be easy. Feel free to post back with questions as you move along with
this.
Good Luck.