ComboBox to select various records?

  • Thread starter Thread starter Randy
  • Start date Start date
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
 
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
Click to expand...

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

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.
 
Back
Top