It ould be a good idea to create a new table eg tblPerformance, and then
create a one to many relationship between tblEmployee (1) and tblPerformance
(M). Then create a form for the tblPerformance, which includes the field
txtPerformaceLink(which is a hyperlink to your performance report). Then you
just make this a continuous form (not a single form). Obviously the form
would have to be fairly small in height to look good. You could also make it
a single form but have navigation buttons to navigate through the performance
reports records.
It may pay to adda command button to help the user insert the hyperlink to
the document/website or whatever. I would create a command button
(cmd_insert_hyperlink) with the following code to open the hyperlink dialog
box where you can navigate to the document you require.
*** CODE STARTS HERE***
Private Sub cmd_insert_hyperlink_Click()
' Set focus to the performance link field
Me.txtPerformaceLink.SetFocus
' Bring up the "hyperlink to" box.
' Is the same as pressing Ctrl + K
SendKeys "^k", False
End Sub
*** CODE ENDS HERE ***
Hope this helps.
Dylan