help on creating a report from results in a form

F

Freeda

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.
 
J

John Vinson

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.
Click to expand...

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]
 
Top