Same Record/Different Forms

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.
 
T

Treebeard

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
 
P

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