Too many values in my report

[4072]

Hi i have a customer table with 2500 entries i would like to somehow have a filter that say's which customre i want and for it only to show the results for that customer. can anyone help me with this ?

 

[jmeadows7]

Have you thought about creating a form with a list box containing your customers. Allow the user to select a single customer, create a query that pulls back the info you need, and base your report off that query.

Then just drop a command button on the form to preview the report.

 

[4072]

thanks mate, i have done exactly that, cheers