Check boxes at end of rows

[NickC]

Hey guys,

What I currently have is a table showing different products over time. This table has the products in the first column, listing each product my company sells in different rows. The second row through the eleventh row is each year from 2005-current. (2005,2006,2007...). In each of the columns showing the year I have it showing how many customers purchased each product in that particular year. I will include a little typed out table at the bottom of my post to show you the layout in a visual way. What I am hoping to do is find a way that I could get a check box at the end of each row, so I could turn on/off looking at specific products. The reason for this is that we have our products grouped in different categories (Commercial Products, Corporate Products, Etc.). It would be incredibly helpful if I was somehow able to select lets say 10 different products from the list of 50, and turn those ones on, while keeping the others turned off. This would allow me to run analyses on these 10 products and look at the different product categories instead of looking at all products as a whole. I have seen this done in my past work experience so I believe it is possible to do, but the person who I had seen do it is no longer with the company so I am unable to contact him and ask how he did it.

I am new at access so if this did not make a lot of sense please let me know and I can try to explain a little better/ attach the document that I am working with. I really appreciate anyone that took the time to read this to see if they could offer some assistance. Thank you guys.

l Product l 2005 l 2006 l 2007 l
-----------------------------


l Prod #1 l 6518 l 6544 l 6559 l [] <------- Check box I am hoping to add.
l Prod #2 l 1148 l 1170 l 1207 l [] <------- Check box I am hoping to add.
l Prod #3 l 9144 l 9523 l 9806 l [] <------- Check box I am hoping to add.

[rpeare]

How are you creating this list in the first place? Is it a table that is getting periodically updated based on 'live' data? Because frankly I would not do any sort of summarizing like this outside of a query and you can change your display of different groups of products in a list box, etc, without adding the checkbox in a data entry/bound form.

For instance if you linked your product to the product category it was part of you could programmatically change the control source of your list box/combo box/form to reflect only a certain group by the choice of which group of products you wanted to see form an unbound combo box.