How Create an Hyperlink from a sub form to a specific record in a form in Microsoft Access 2007/2010

Question

Hello I am working on a project for school and I have a sub-form which with StudentID as the primary key and I would like to make EACH StudentID an hyperlink that links to a form that will show the full details of that student.

How can I do this? Please Help.

Answer 1

Depending on whether your list of students is in a listbox or on a bound form you can capture the dblclick event of the row. On the double click event you could launch your next form and use the OpenArgs property to pass it the student ID. Then on your second form's load event you could run an SQL using the OpenArgs (StudentID) to get your desired data.