ms_access-forms to reports

Question

I created a form in access. I created a combo-box to display all clients, once a particular client is clicked a sub_data-sheet appears showing the (many) details of that client(in table form)

Now I need to create a report listing that client name with that clients details as the form has it, the twist come when the report must be able to contain more than 1 client,

how do i go about doing that,

thanks a mil

Answer 1

You should create a report and subreport; use the query that the combo is based on as the recordsource for main report and the query that the subform is based on as the recordsource for the subreport.

This does not seem to be a programming question.

Answer 2

You just need to filter the report when you run it. I don't know if you have a command button on a form-maybe two. Your vba could look like this.

'Single Client using a filter on the combo box value (Assuming some sort of Client identification number) DoCmd.OpenReport , acViewPreview, , "[ClientID]=" & cmbClientID, acWindowNormal

'All clients DoCmd.OpenReport , acViewPreview, , , acWindowNormal