Code for printing only one report based on customerID

[leaners]

what am I doing wrong?

My report is called Booking and my primary ID is called CustomerID. The report is meant to print an invoice specific to the customerID i.e. for the current booking.

The report displays every booking instead of the one specific top the customer. The code is attatched to a button called invoice. Please help.

Code:
Private Sub Invoice_Click()
Dim strDocName As String
Dim strWhere As String
strDocName = "Booking"
strWhere = "[CustomerID]=" & Me!CustomerID
DoCmd.OpenReport strDocName, acPreview, strWhere
End Sub

 

[leaners]

Is there any other method for previewing an invoice based on customerID?

 

[TheAceMan1]

How are ya leaners . . .

Apparently CustomerID is on [blue]the many side[/blue] of a table. Use the [blue]PrimaryKey[/blue] of the table instead. If you don't have a PK (bad idea in this case) you'll have to [blue]include some other unique field[/blue] . . .

See Ya! . . . . . .

 

[PHV]

DoCmd.OpenReport strDocName, acPreview, [!],[/!] strWhere

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886