Form-Report question? (1 Viewer)

tico78

Registered User.
Local time
Today, 15:42
Joined
Mar 10, 2003
Messages
14
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
 
Last edited:

AccessAmateur

Registered User.
Local time
Today, 10:42
Joined
Feb 13, 2003
Messages
30
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

Registered User.
Local time
Today, 15:42
Joined
Jun 15, 2000
Messages
719
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
 

Users who are viewing this thread

Top Bottom