Form fields to Report

I have been over the forums here, and I'm not sure if I have a unique
situation, or I'm doing it wrong.

I have a form with 7 listboxes. Each one is unbound, and the results
chosen by the user are fed to the report.

I also have checkboxes that are bound to a query.

I am only able to display the data in the listboxes OR the checkboxes
on the report, not both.

The other issue is that I want to have the form bound to a specific
client. The information shown on the form is for that client only.
That information gets updated, and sent into the report to print out.

I would like the report to show that it is reading the client's
information from the form from the listboxes AND the checkboxes when
it is in report print preview.

Any help you could give me would be appreciated. I've already been
through (and was helped by) the link http://allenbrowne.com/ser-50.html.

Re: Form fields to Report

On Nov 1, 2:52 pm, mbolokof...@seniorneighbors.org wrote:
> I have been over the forums here, and I'm not sure if I have a unique
> situation, or I'm doing it wrong.
>
> I have a form with 7 listboxes. Each one is unbound, and the results
> chosen by the user are fed to the report.
>
> I also have checkboxes that are bound to a query.
>
> I am only able to display the data in the listboxes OR the checkboxes
> on the report, not both.
>
> The other issue is that I want to have the form bound to a specific
> client. The information shown on the form is for that client only.
> That information gets updated, and sent into the report to print out.
>
> I would like the report to show that it is reading the client's
> information from the form from the listboxes AND the checkboxes when
> it is in report print preview.
>
> Any help you could give me would be appreciated. I've already been
> through (and was helped by) the linkhttp://allenbrowne.com/ser-50.html.

What you need is one function that is called from every control in
each controls' AfterUpdate event. This function should create the
query for the report based on the values in every control.