Linking forms

[GavZ]

Please please please help me!!

Firstly to set the scene i am trying to create a training DB.

I have a form with one textbox in it which is for the course title. I then have a continuous subform with all the peoples details in it and whether they are trained or not.

There are nearly 40 courses and 33 people.

The problem i have got is that i want the list of people to stay constant in each course but this the gives the problem of the 'Course Completed' checkbox. BECAUSE if i link the subform to the mainform and a new person starts you have to go through every course and add them and if i dont link the forms the 'Course Completed' checkbox stays the same!

Is there anyway to have it so that the list of people in the subform stays constant even when one is added to the table but the checkbox gets updated?

I have tried this many different ways like adding the checkbox as a subform etc etc but with no luck!

If you can think of a better way i am VERY open to ideas - Thanks in advance!!

 

[GavZ]

Does no body know what im going on about? It is a little confusing i know but any help would be very much appreciated!

 

[Fear Naught]

You perhaps need to look at the data a different way. Try having a main from with the persons details and a subform with course details so that you can check a particular person against a given course. The sub from should show all courses (unless you filter them based on a persons status/role etc.

The subform that you already have should show all people in your people table.

This solution will provide you with 2 ways of managing course complettion.

I hope this helps