GUI buttons to show reports?

[brownk]

Hello everyone, i apologize in advance for what I'm about to ask but since i don't know what its called i cant really do a search for the topic and get any worthwhile results. I've been working on a project to created automated reports. Everything went fine and my reports look good. What i want now is a little GUI interface to run with several buttons, each of which opens a different report. What is this process/feature called? I just need pointed in the right direction. Thanks!

[alansidman]

ComboBox.mdb


You want to add command buttons. You can use the Access Wizard to help with this. With your form open in design view, click on the comman button from the available controls to add to your form. Follow the wizard.

Another Option is to create a form similar to the one I have attached. This one allows the user to select a query from a combo box and run it. In your look up table, the value for Queries under the type field is "3", for reports you would use "-32764". You have to unhide the system tables so that you can see the mSysObjects table to see what is in there. Rehide it after you set up the combo box. Look at the code behind each of the controls. This is quick and easy to set up.

Alan

[brownk]

Thank you very much!