Multi Select list box with date range to print command button on f

G

Guest

I have a database with multiple queries feed reports. There are up to 40
need to be printed daily however not all need to be printed daily. I want to
give the user a form to fill in start date, end date range and pick which
reports to print. I have tried many options so anything new is helpful

Table feeds multi queries which then feeds its own report. (table master -
query Auto Loan - report Auto Loan) This form will give the user the option
of printing several reports with the same date range.
 
G

Guest

I don't quite understand what you are saying about the table you have, but
what you need is a table that has the description of each report and the
object name of the report.
Create a two column multi select list box. Make the first column the name
of the report and the second column the description. Make the column Width
of the first column 0 so the user will see only the description. The first
column should be the bound column.

Once the user has entered the dates and selected the reports, use the list
box's itemsselected collection to print the reports.

With Me.MyListBox
For Each varItem In .ItemsSelected
Docmd.OpenReport .ItemDate(varItem)
Next varItem
End With
 
G

Guest

Forgot to mention the table I described should be the row source of the list
box.
 

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

Top