Unanswered: how to make data appear automatically in subform?
I have a table called CourseCollege Dates containing 3 fields: Course ID, Start Date and End Date.
I also have a table containing all details on the candidates for this course.
In the candidate Form which is used to enter in all the details, i have a subform, in this subform i want to be able to enter the Course ID '1' and the rest of in the information (start date and end date ) to automatically appear.
At the moment it just displays both sets of course details.