help on creating a report from results in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Freeda - 18 Apr 2006 18:27 GMT

I have a form with two multi-select list boxes then a command button to run
the query. The results are then displayed on another form. Here is where my
problem starts. I want to be able to print the results. I created a print
form button via the wizard but it just prints the form and not the data in
the form.

Reply to this Message

John Vinson - 19 Apr 2006 18:35 GMT

>I have a form with two multi-select list boxes then a command button to run
>the query. The results are then displayed on another form. Here is where my
>problem starts. I want to be able to print the results. I created a print
>form button via the wizard but it just prints the form and not the data in
>the form.

Create a Report instead. Forms are not designed for printing.

Base the Report on a query which selects the desired data, and have
your button open the Report.

John W. Vinson[MVP]

Reply to this Message