switchboard form button

[Guest]

Is there a way to add a button on my startup that when a user clicks on it a
drop down list appears, I have reports and on the switchboard form the user
sees, I want them to be able to choose without having to type in the name,
example I have a report that runs all the emp in the Records Division,
Teleserve, Information and Technology etc. I want them to be able to click
on the button and the list appears and they can choose. I know in my query I
have it to pop up and they can type in a few letters and then run the query.
We have a lot of divisions and sections, I just want them to be able to
choose, so there will be no mistakes on typing.

Thanks,

 

[Allen Browne]

You create a form, with a combo or list box that shows the reports to choose
from.

If you want to specify the report names yourself, you can set the list/combo
box's RowSourceType to Value List, and type the names of the report in. Each
one goes in quotes, with commas between them.

If you want Access to supply the names of all reports for you, see:
List Box of Available Reports
at:
http://allenbrowne.com/ser-19.html