Create new record with an empty subform

[Mick Randle]

I have created a main form, containing personal records on individuals. Then a subform to contain records of training they have recieved.

Problem: When I add a new record (new person to the database) the subform for the person is populated with the data from the previous. I want each indvidual to have thier own recod of training starting with a blank canvas for eah new entry ??

Any ideas, can you guess I'm not brilliant at access, but trying.

 

[John W. Vinson]

I have created a main form, containing personal records on individuals. Then a subform to contain records of training they have recieved.

Problem: When I add a new record (new person to the database) the subform for the person is populated with the data from the previous. I want each indvidual to have thier own recod of training starting with a blank canvas for eah new entry ??

Any ideas, can you guess I'm not brilliant at access, but trying.

What are the following properties:

- The Recordsource for the mainform
- The Recordsource for the subform
- The relationship between the personal records table and the training table
(what fields are they related by?)
- The Master Link Field and Child Link Field of the Subform