Combo box on form for opening reports

[davidjearly]

Hi guys,

I'm new to this forum and apologise for making my first post one that requests help. I came across this site by searching my problem in Google. However, that thread ended up not being what I was looking for, or at least, I didn't understand it.

What I am trying to do (as per the title) is the following:

In my database, I have a form, on which I would like to have a combo box showing a menu of all the reports I have created.

When I click on the name of a said report, I would like it to open. I don't mind if it does this by clicking on a command button after selecting the report, or it if opens as soon as the report is selected from the menu without any command button.

So, if I have a collection of reports titled 'Report 1' through 'Report 7', how would I go about this?

I have created a table with two columns. One column contains autonumber fields, and the other column contains the names of the 7 reports I have.

However, the way I have it set up at present is such that the 7 report names are displayed when I click on the combo box in the form, but selecting them does nothing.

I would really really appreciate some help!

P.S. I am using Access 2007.

 

[HiTechCoach]

This example may be helpful:

Report Dialog Examples

 

[davidjearly]

Is there an example in that database you were referring to? I don't see anything on the forms similar to what I am looking for (although the calendar template will come in handy later).

 

[HiTechCoach]

The two "Report Menu Dialog" example do exactly what you want and more. They just use a List box, not a combo box. I know that you said that you are using a combo box and not a list box, but they work so much alike that the examples that use a List box can be applied to using a Combo box.

Note: You can import the objects into your database and use them if you want.

 

[davidjearly]

The two "Report Menu Dialog" example do exactly what you want and more. They just use a List box, not a combo box. I know that you said that you are using a combo box and not a list box, but they work so much alike that the examples that use a List box can be applied to using a Combo box.

Note: You can import the objects into your database and use them if you want.

Many thanks for your response.

I see the two forms you mention, and I don't mind using a list box instead of a combo box. When I import them into my database, how do I link the two list boxes to the reports in my database?

For example, I have a group of reports called 'North Reports', which I would like to appear in the left list box, and then 7 other named reports which I would like to appear in the right list box.

Sorry, but I'm fairly new to doing things like this in Access.

Thanks again.

 

[HiTechCoach]

I did not mean that you have to use list boxes. You can use cascading combo box if you like. I was just trying to point out that the code would be the same or either type of control.

The example uses tables to store the configuration data. On the example's main menu, the right two command buttons (the Utility forms)are used to edit the configuration data.

 

[davidjearly]

Well, what can I say? It worked! Thank you. My next query involves reporting by period.

I notice that there is also an option in your template to have it run off reports based on dates? Is there a way that I can run reports based on a period? For example, my reports are based on individual practices which are reviewed 6-monthly. Each review would be numbered so, I would like to be able to run reports based on a period number (not date). This would be, period 1, 2, 3 ect. However, as there are many practices being reviewed at different times, these periods are not tied to dates.

In my tables containing practice data, I could include a column called 'period', and number it 1, 2, 3 ect... if that would work.

Any tips on how to implement this into the form?

Again, thank you for your help.