Hey everyone. I am trying to make a form that allows me to sort items by product type and compare an individual aspect of those products selected. Right now my report will print all of the products of one type, along with about 10 descriptive information boxes, but I would like to create a seperate report for quick viewing that shows an individual product line and all of the part numbers, and compares just one selected aspect between all of them.
Right now the report is pulling the part numbers of a specific product type off the main combo box that all of the values are listed on.
I also have a combo box that lets the user pick one of the 10 comparative aspects (basically selecting a table). Now I am trying to figure out if there is a way to have a second combo box that lets the user pick from the values in the table selected with the first combo box. Is anyone able to walk me through how to do this?
Sorry for the lengthy post, and thanks for any help in advance.
Right now the report is pulling the part numbers of a specific product type off the main combo box that all of the values are listed on.
I also have a combo box that lets the user pick one of the 10 comparative aspects (basically selecting a table). Now I am trying to figure out if there is a way to have a second combo box that lets the user pick from the values in the table selected with the first combo box. Is anyone able to walk me through how to do this?
Sorry for the lengthy post, and thanks for any help in advance.
