ComboBox to select various records?

R

Randy

Can a comboBox or something similar be created on a form to select various
reports. I have 10 reports that I would like to select from a list for
previewing on a form...Thanks...Randy
 
D

Dirk Goldgar

Randy said:
Can a comboBox or something similar be created on a form to select
various reports. I have 10 reports that I would like to select from
a list for previewing on a form...Thanks...Randy

I'm not sure I understand what you're asking. You can set a combo or
list box to a query that returns a list of the reports objects defined
in the database, though I prefer to use my own table of reports so that
I can give the reports "friendly names", exclude subreports, and control
the list order. What exactly is it you want to do?
 
R

Randy

I have 10 reports that I would like to select and review from a form. A
list would be nice to select an individual report for viewing.
 
D

Dirk Goldgar

Randy said:
I have 10 reports that I would like to select and review from a form.
A list would be nice to select an individual report for viewing.

If you want to display all reports defined in the database, you can use
this as the rowsource for a combo or listbox:

SELECT MSysObjects.Name FROM MsysObjects
WHERE (Left$([Name],1)<>"~")
AND (MSysObjects.Type)= -32764
ORDER BY MSysObjects.Name;

Or else you can create your own table of reports, and set the rowsource
to a query of that table.
 

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