Report per client


G

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top