Limiting a drop-down list of reports

[BrookieOU]

Hey all, I have a problem I am trying to figure out. I have a form that has
a drop-down list of my reports. What I am trying to do is limit the
drop-down list to only certain reports (i.e. I have a form with a list of
employee and only want the drop-down to show employee reports). Anyone know
if this is possible or the code I would use to do it? The coded event I am
using for the reports is the MySysObjects one.

Thanks,
Brooke

 

[Jeff Boyce]

Brooke

One way to approach this is to create a table of your own that lists the
reports, and a "category". Then you'd have the user first pick a category
of report (e.g., "Employee"), and use that selection to limit the reports
displayed (search "Cascading Comboboxes" for the technique).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BrookieOU]

That sounds logical. Thanks, I'll try that.

Brooke

One way to approach this is to create a table of your own that lists the
reports, and a "category". Then you'd have the user first pick a category
of report (e.g., "Employee"), and use that selection to limit the reports
displayed (search "Cascading Comboboxes" for the technique).

Regards

Jeff Boyce
Microsoft Office/Access MVP