Hello,
I have a combo box that has a row source connected to a table. The table has a list of four Categories with an Order column (1-4). There is a second table that has two columns: one with a list of Names, and the other with a Categories column which corresponds to the categories in the first table. I would like the combo box to select a Category for a Name that is selected from a previous combo box. When I click the combo box, the Categories appear fine. However, I can't get it to update the table that contains the Names and Categories. Am I missing something?
I have a combo box that has a row source connected to a table. The table has a list of four Categories with an Order column (1-4). There is a second table that has two columns: one with a list of Names, and the other with a Categories column which corresponds to the categories in the first table. I would like the combo box to select a Category for a Name that is selected from a previous combo box. When I click the combo box, the Categories appear fine. However, I can't get it to update the table that contains the Names and Categories. Am I missing something?