Assign constants to combobox rowsource

[klnlsu]

I have a combobox on a form that is assigned to a value list. The rowsource has "Bend";"Puncture";"Torsion";"Impact";"Tension" on the combobox property sheet. My question is how do I duplicate this in VBA. Depending on the value I put in another combobox, I want to edit the values available in this combobox. I tried the following code:

If Forms!frmHeaderEntry!PipeTypeCombo = "Non-UL" Then
TestTypeCombo.RowSource = "Bend"


Else
TestTypeCombo.RowSource = "Bend";"Puncture";"Torsion";"Impact";"Tension"
End If

but I get a syntax error on the line in red (the line with the single value works). I have also tried putting commas between the values. I have also tried removing the quotes. Neither works. What is the proper syntax to accomplish this? I know I can put the values in tables and assign the tables to the rowsource, but I want to keep this little database simple and straightforward.

Thanks.

[ranman256]

try never to assign values to a combo box.
Always use a table/query. Easy to maintain/change.
dont do it in code.
use the table/query as the source.

[pbaldy]

I would also use a table, with another field that let me determine which items to select for different options in the first combo. It would be more dynamic and maintainable. That said, the solution might be:

TestTypeCombo.RowSource = "Bend;Puncture;Torsion;Impact;Tension"

[Micron]

Depending on the value I put in another combobox, I want to edit the values available in this combobox.

The answer to this part of your post would be that this is commonly known as 'cascading' combo boxes. Lots of web pages available on the topic.

[CJ_London]

if using a list string, you also need to change to combo rowsource type from table/query to value list