using check/combo boxes to make a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I should preface this be saying I am a relative beginner in Access, so small
words are helpful. I have linked an Access table to an Excel spreadsheet
where we enter information on how our homebuyers found out about our
communities. We track 14 different criteria at 13 communities. I have
figured out how to create a bar graph for each community individually by
running separate query for each location.

I know I can design a form that has multiple buttons for printing each
report based off the individual queries and that will suffice for the
powers-that-be. However, for my own edification I would like to do something
more complicated. I would like to figure out how to use either a series of
checkboxes or a single combo box to select the communities for which reports
should be generated. I want to use a single query as the data source.
Ideally, the user should select the checkbox(s) that they want a report for,
press a button and Access will generate a chart. And if that is not asking
too much, I would like an “All†option so that all communities can be printed
at once.

If I am way outside the bounds of reality then feel free to smack me down,
but if my ideas are somewhat reasonable then I appreciate any help.

Thanks
 
I would suggest either a combo box or a list box rather than check boxes. If
you use check boxes, then each time you add or close out a community, then
you would have to modify your form. The advantage of a combo box is that it
has a NotInList property that would allow the user to add a property to the
list. The advantage of a list box is that you can make multiple selections.
In either case, I would suggest you create a table that would have the names
of all your communities. You could also add the value "All" to it, and
handle that selection programmactically. I do know there is a technique for
adding a value like "All" to the results of a query based on your table, but
I have never used it. If you search around in the news group, you may find
it. I have seen the question and answer a few times, but have not paid
attention to how it is done.
 
Back
Top