Passing value from parent to child form

[Pragmatic]

Hello all, I have 2 table as follows:



Table 1: StudentID, Student Name

Table 2: CourseId, StudentID, Course Name

What I want to achieve is when I complete student's details in the student form there is a button on the form which asks "Do you want to enter the course details" when this button is pressed it should open up another form with default StudentID and generate a auto courseID and allow the user to input the rest of the course details. Please note I am using Access 2003. Any advice help with example will be highly appreciated.

[Amicron]

If you want to use two different fields, you can just set the Default Value of the StudentID on the COURSE table to:

=Forms!StudentTable!StudentID

However, I would recommend setting this up as a Form/Subform. Set up the LINKED FIELDS properly in the form settings and Access will handle this for you.