Same Record/Different Forms

  • Thread starter Thread starter Scott
  • Start date Start date
S

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.
 
Scott said:
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.
Click to expand...

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
 
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.
 
Back
Top