diary entry field in ms access

[Guest]

I need to install a diary entry field within a form to record any notes.
This is a membership group database and I provide the administration support
on a voluntary basis.

I will be using a notes box to record any health issues etc......but would
also like a date entry field to record any issues/ comments that need to be
made on student progress etc.

 

[Guest]

Hi

you could add a field to the table format a memo. Add this to the form to
allow addition of notes.

Or create the new field as above and create a popup form with just this memo
field and the primary field (ID). Then on the main form add a button to open
the popup

Use this behind the OnClick event of the button

Private Sub ButtonName_Click()
On Error GoTo Err_ButtonName_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "PopUpFormName"
stLinkCriteria = "[IDFieldOnPopUp]=" & Me![IDFieldOnForm]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ButtonName_Click:
Exit Sub
Err_ButtonName_Click:
MsgBox Err.Description
Resume Exit_ButtonName_Click
End Sub