Hi.. Thanx to all in advance for taking the time to read & attempt to solve my problem
I have a make table query that lists a 100 countries and the average rain precipitation for each month of this year and the previous year.
An example of what the table and graph look like have been attached in the excel file. Note that the numbers are just random nos.
I need to create a form where a user can choose a country from a drop-down box and after clicking a button, it shows a line graph plotting two lines for the 2 years for each month like a time-series. I also need to add 2 print buttons on the form; one button to print the user inputted country's graph, and another PRINT ALL button, that automatically prints the graphs for all 100 countries. FYI.. I've created the form already and have a show button, which when clicked on goes to a query which calls the make table, and opens it in pivotchart view. If this method is not right to answer my following questions, plz explain if there's another option to get the graph allowing to print it.
Can anyone help in creating this drop-down menu with a list of the countries if I have the countries in the make table, TBL_CNTRIES? Also, how do I go about the 2 print options, especially the PRINT ALL button?? If I need to write a module for this, what would it look like?? Any help would be appreciated.