i need to create a form that is based of off information in a table. there needs to be 7 combo boxes that will filter this information based on any combination of the selected combo box values, or if none are selected a summary of all the data.
i have the created the form with the table. i have made several attempts with the combo boxes and have managed to alter the table values when using them, but not how i would like.
my biggest concern is how to make the combo boxes function properly. i tried writing SQL statements for each box in the Row Source section of the Property view (using the Query Builder) but have had only mixed results.
this problem has been troubling me for about a week now as i cant seem to find the best way to make this work. i know it's a topic of frequent discussion when it comes to forms, so im sure someone here can help

please tell me if you need additional info on the problem. thank you thank you.
edit:using Access 2007
i have the created the form with the table. i have made several attempts with the combo boxes and have managed to alter the table values when using them, but not how i would like.
my biggest concern is how to make the combo boxes function properly. i tried writing SQL statements for each box in the Row Source section of the Property view (using the Query Builder) but have had only mixed results.
this problem has been troubling me for about a week now as i cant seem to find the best way to make this work. i know it's a topic of frequent discussion when it comes to forms, so im sure someone here can help


please tell me if you need additional info on the problem. thank you thank you.
edit:using Access 2007
Last edited: