Multiple Rowsource

[qazxsw123]

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.

[June7]

What is 'corresponding type'? I don't understand - why would a combobox NOT have multiple choices?

It does sound like you want what is called 'cascading' or 'dependent' combobox. This is a common topic.

If you want to provide db for analysis, follow instructions at bottom of my post.

[qazxsw123]

What I mean is I have a list of chemical types and each chemical type has a number (1,2, or 3) associated with it. When someone chooses the chemical type in the combobox, the other combobox automatically updates with the number being displayed. What I want to have happen is keep that function as is but, also give the user the ability to choose another number if they want to. Ex. you choose chemical a from the combobox, the other combobox then returns the value of 1 but, that is the only number being displayed in the other combobox. What I want is to give the user the ability to change the number with values of either 0,1,2, or 3.

[June7]

Sorry, still don't understand. Why is combobox 1 selection displayed in combobox 2?

If combobox LimitToList is set to No, users can type whatever number they want.