How do I show full text for separate entries in selected field?

  • Thread starter Thread starter Mark J. Wilson
  • Start date Start date
M

Mark J. Wilson

We have a database of contacts. Each contact has several differenct entries
of notes. Some of the notes are quite lengthy. How do we design a report
that includes a menu to select just the contact name we want to run a report
on, and that will list the full text of each note for that contact? Thank
you!
 
Presumably you have a table of Contacts, and a related table of Notes. The
Notes table will have a ContactID field (foreign key to Contacts.ContactID).

If so, you can restrict the report to the notes for one contact.
Create a form with a combo box (for selecting the contact), and a command
button to open the report.

The Click event procedure of the command button will be something like this:

Private Sub cmdPrint_Click()
Dim strWhere As String
If Not IsNull(Me.cboClientId) Then
strWhere = "ClientID = " & Me.cboClientId
End If

DoCmd.OpenReport "MyReport", acViewPreview, , strWhere
End Sub
 
Back
Top