Create new record with an empty subform

  • Thread starter Thread starter Mick Randle
  • Start date Start date
M

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.
 
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.
Click to expand...

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
 
Back
Top