Report per client

[Guest]

I have a database where I have Client Information , Questions and Responses.
I now want to do a report on all the Responses with the question per client.
My responses table has the ClientID field in as well as the QuestionID
Both being PM for the relative tables.
I need to create a way that I can have the report as a an item on my
switchboard where
You can select the clients ID and from there the report will get generated
for that client only.
Can you please tell me how to do this?
Natasja

 

[Guest]

I assume you have a combobox that lists Clients with the ClientID being the
bound column. In the click event of your button, put:

Dim strWhere as string
strWhere = "ClientId = " & Me.cboClients
Docmd.OpenReport "rptClientReport", WhereCondition:= strWhere

I'm assuming in this example that your ClientId field is a numeric field.

HTH,
Barry