Single report

[Socold]

Was hoping to get some help with a problem I have.

My database is built around an building inspections business, the tables I have are clients, jobs, contracts, inspections and notices. what I want to be able to do is produce a PDF from either a contract or notice from a single client, ive been able to create the reports that I could format to contain the information I need, but the PDF has all the contracts or notices from every client not just the one.

contract.pdf

as you can see in this example all clients are there, I want to be able to produce a PDF with only one client.

[dhannant]

Personally, I would write some code for an inputbox that would the filter the report... something similar to this below:

Dim lname As String
lname = InputBox("Enter Last Name", "Name Required")
'On Error Resume Next
If StrPtr(lname) = 0 Then
      MsgBox "Edit Record Cancelled", vbInformation
      GoTo EditRecord_Click_Exit
Else
      If Len(lname) = 0 Then
            MsgBox "Please enter a name to edit", vbCritical
            GoTo EditRecord_Click_Exit
      Else
            DoCmd.OpenForm "New Employee", acNormal, "", "", acEdit, acNormal
            DoCmd.GoToRecord acForm, "New Employee", acLast
            DoCmd.FindRecord lname, acEntire, False, , False, acCurrent, True
      End If
 End If