Problems running a report from tables

[mb1980]

Hi, I have setup a report to run from a table I have created, now what I want to do is set this so that I can choose to see only certain items on the report, example: I place order details onto the table and want to view one order on the report, how do I set it so hopefully I can choose which order to view and this comes up in the report?

Any help would be greatly appreciated
Thanks.

 

[Brianwarnock]

This is why we never base reports on tables always on a query, the query can have criteria.
Use an unbound form to enter the criteria and a command button to preview the report.

search Forum on query by form for further info if required.

Brian