Private Sub OpensubFrm_Button_Click() DoCmd.OpenForm "subFrm", acNormal, , "[Stud_ID] = " & Forms!mainFrm!Stud_ID Forms!subFrm!Stud_ID = Forms!mainFrm!Stud_ID End Sub
subfrm
mainfrm
SELECT * FROM SecondTable WHERE Stud_Id = Forms!MainFrm!Stud_ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)