I can't figure this out but I don't think its that hard. Hopefully someone can help me here:
I have an Access 2003 DB for Classes, Students, and related info.
The first form involved in this problem is called "Classes" showing simple contact info. This form contains a sub-form called "Classes Subform" showing the students that have enrolled in that particular class. On "Classes Subform", the list of students enrolled in the Class are shown in Form view. The fields on the "Classes Subform" are 'Student ID' (a combo box...displaying First and Last Name of Student from SQL query), 'PhoneNumber' (a textbox), 'EmailName' (a textbox), and 'ParentsNames' (a textbox).
I am trying to add functionality so that when a user double-clicks on a students name on "Classes Subform", the form "Students" opens with all of the related Student info. I would also like to add a control button with the same functionality. The field on "Students" is also called 'StudentID'.
All of my attempts at this have failed. I'm missing something simple here but I know its a simple link on the 'double-click event', etc. Any help is much appreciated. Thanks!
Start Free Trial
