I am working on a form for work. I have a table/query rowsource and before that I have a chemical type to choose from. After choosing a chemical type the other combobox automatically populates its corresponding type but, I also need it to provide a list of other choices from a combobox. Ex. someone chooses a chemical type and the other combobox now has a '3' as the corresponding type. I then also need the second combobox to offer other types from a dropdown list (ex. also have 0,1, and 2) as other possibilities.