Linking tables using form and subform

[Guest]

I have a database for use in a martial arts school for registration, and have
created a table (Members) for parent information and (Students) for student
information. Member ID is the primary key in Members and Student ID in
Students.

The Members table is linked to Students table by Member ID on a one to many
basis, and I have created a form to enter Member information with a button to
open subform for student data, but my problem is that when I enter student
data the Member ID is not linking, so I get a Member record and a Student
record, but the student record has a blank Member ID field.

How can I link these so that the auto number from the Member ID field in
Members is automatically added to the Member ID field in Students?

 

[Guest]

Hi Anthporter,

You want to have your subform actually embedded in your main form, then set
the Link Child Field/Link Master Field properties, and Access will handle the
linking for you!!

Damian.