Need List to Show Only Entries for User-Entered Account #

[italianfinancier]

I have a Form that users enter a customer number into and a Report is generated based off the customer's information in a Table. The problem is, when the report generates, it just puts that customer's data on the top row, but shows all the other customers data below it. I need it to only show the customer entered into the form please. Any help would be IMMENSELY appreciated. Does it have anything to do with the Control Source field in the Preferences of the list in the Report?

~ Chris

 

[apr pillai]

Try opening the Report from a Button Click Event Procedure with a Filter Condition like:

Private Sub cmdReport_Click()
Docmd.OpenReport "MyReport",acViewPreview,,"[B]CustomerAccount[/B] = " & Me![[B]CusAccount[/B]]
End Sub

Change the Data Source field: CustomerAccount and the Form TextBox name: CusAccount values to match the actual names.