Open one form from another form passing the linked field

[AndyRob1973]

Hello all,


I have a main table (students) with students basic information (eg name, Date of birth, address, contact number) and have made a form. The primary key is StudentID.

StudentID (PK)
Name
DOB
Address
Contact Number

I have created another table (demographics) where I want to hold the student’s demographic details

DemographicID (PK)
StudentID
Gender
Ethnicity

I have linked these tables in ‘relationships’ (with ‘enforce referential integrity’, ‘cascade update related fields’, ‘cascade delete related fields’, all ticked) on StudentID.

I have then made a form from the students table and another form from the demographics table. I would like to open the student form and input details then click on a button to open the demographics form and fill in the demographic details for that student. How do I get the StudentID to be passed when I open the demographics form so that I’m adding this data to the correct student?

Could anyone help please? I suspect this is easy but I'm struggling.

Thankyou

[davegri]

Having two tables make little sense. This is a one-to-one relationship. Student gender and ethnicity is constant and should be in the Students table. No demographic table required.

However, if there is a reason for separate tables, check out the Openargs parameter for DoCmd.Openform

[ranman256]

on the main form is fStudent
add a subform fDemoSub, (the tDemo table)

set the properties on the subform:
LINK MASTER FIELDS: StudentID

LINK CHILD FIELDS: StudentID

then just fill in the subform fields. (studID fills itself)

[AndyRob1973]

Thankyou both

I’m sorry – my question was a really clumsy way of asking for what I wanted by using a made up example!
Basically I would like to know how to open another form rather than just have a sub form. A better example might be a student form and an Emergency Contact form (one to many)

StudentID (PK)
Name
DOB
Address
Contact Number

Emerg_ContID (PK)
StudentID
Name
MobileNum

I understand that I could have it as a subform but would like to know how to open the EmergencyContact form for that student, by pressing a button on the Student form
Thankyou and sorry for the confusion!

[Welshgasman]

I would use OpenArgs https://docs.microsoft.com/en-us/off....form.openargs