how do i update and sort values in combo box after click on the combo? combo is bound to a table
N nermin Jan 31, 2005 #1 how do i update and sort values in combo box after click on the combo? combo is bound to a table
W Wayne Morgan Jan 31, 2005 #2 Bind the combo to a query instead of a table. The query will let you sort. What are you wanting to update after selecting a value in the combo box? Do you have two combo boxes and you're trying to filter the second one with the first one?
Bind the combo to a query instead of a table. The query will let you sort. What are you wanting to update after selecting a value in the combo box? Do you have two combo boxes and you're trying to filter the second one with the first one?
S Sprinks Jan 31, 2005 #3 Hi, Nermin. I'm not sure I understand why you'd want to do it after clicking on it, but you'd set the RowSource property and requery the combo box: Me!MyComboBox.RowSource = "Select MyValueList From MyTable Order By SortField" Me!MyComboBox.Requery Hope that helps. Sprinks
Hi, Nermin. I'm not sure I understand why you'd want to do it after clicking on it, but you'd set the RowSource property and requery the combo box: Me!MyComboBox.RowSource = "Select MyValueList From MyTable Order By SortField" Me!MyComboBox.Requery Hope that helps. Sprinks
