Form-Report question?

[tico78]

A new Form-Report question?

1. I need to make a report of every client with his information stored my database (Access). HOw can I do that? Do I need to create a comand button in the form of the client?

2. How to create a button in the Client's Form that prepare a REport of the information contained in the form?

I tried, but I get just one report with all the clients and their info (in just one report), and I need a report of every client individually..
please HELP!
thanks

 

[AccessAmateur]

Probably what you want is to create a query which filters the data to a single client then base your report on the query not on the main table.

 

[KevinM]

You only need ONE report.

On the code that opens your report from the command button add a WHERE condition in the 'Docmd.OpenReport' line, referencing the PK field on the form.....

i.e "MyID= " & MyID