need help in creating report! please (1 Viewer)

[tico78]

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?
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

 

[MikeAngelastro]

Use the following code on the click event of the button:

DoCmd.OpenReport("Report Name", , "Client = " & QUOTES & Me!ClientID & QUOTES

"QUOTES" is a constant which you will have to create in a module making it equal to """" Use of this constant will only be necessary if the ClientID is a string.

This will limit the report to the client the form is showing.

You may want to look up the command in Access Help first to find out what it all means.