help on creating a report from results in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Access Access Report Works on One Machine but not Another 3
print report off a selection from 2 list boxes 2
Access Sub form opens before the main form in MS Access 0
Create a button that prints the selected record of a report 4
Query help 3
Re: Pass field value selected in Combo Box to SQL Query 1
Access Determine what query to run based on a checkbox 0
Select report(s) to print via multi-select list box Access 2003 2

Back
Top