Sort value list in Combo

[Mats]

Does anybody have the code for sorting the value list in a combobox? (or any other string of values with a common separator)<br><br>Thanks,<br>Mats

 

[DougP]

I assume your combo box is connected to a Query if not make it so.<br>Then in that query sort the column you want.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Mats]

Actually I was more curious to sort the actual rowsource of a ComboBox with a value list (you know: string1;string2;...).If I have a combo with limittolist=yes and a valuelist of string1;string2 and the notinlist function combo.rowsource=combo.rowsource & &quot;;&quot; & newdata then any new string gets added to the end of the list and not the place given by alphabetical order. I know I could do it with a query and table but I was just curious to how this solution would look like.<br><br>Mats