How do I get my Report to only show data on a certain customer?

[italianfinancier]

I made a report that I want to only show data on a particular customer (based on a customer number that a user enters). How do I do that?

[SoftwareMatters]

I made a report that I want to only show data on a particular customer (based on a customer number that a user enters). How do I do that?

Like this:

DoCmd.OpenReport "ReportName", acPreview,,"CustomerNoFieldName=" & Me!FieldName

Just replace the following:

ReportName = the name of the report

CustomerNoFieldName = the name of the customer no field in the report recordset

FieldName = name of the field where the user chooses a customer