Same Record/Different Forms

[Scott]

I select student Joe Smith from a student record form.
Need to switch to different forms (Testing, Attendance,
etc.) for other data related to this student and keep the
focus on this same current record. These various forms
will have different querys as their data sources. What
code should I use to accomplish this and should it be in
Current, CLick or some other event?
Thanks for your help.

 

[Treebeard]

I select student Joe Smith from a student record form.
Need to switch to different forms (Testing, Attendance,
etc.) for other data related to this student and keep the
focus on this same current record. These various forms
will have different querys as their data sources. What
code should I use to accomplish this and should it be in
Current, CLick or some other event?
Thanks for your help.

There's several ways to do this. One way is a button with the following in
the "on Click" event.

Dim strCriteria As String, StudentNum As Long

strCriteria = "[StudentNum] = " & Me.StudentNumber
DoCmd.OpenForm "frmTestResults" , , , strCriteria

 

[PC Datasheet]

Scott,

You might consider using a tabcontrol with multiple pages. You would put the
Student Name at the top of the screen and the tab control below the name. On
each of the pages of the tabcontrol you could put something different about the
student: Home Address, Class Standing and Activities, Testing, Attendance, etc.