Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sat Apr 5 10:04:16 CDT 2008
Dear List: I have a combo box on a form which allows the user to select how they want the records sorted. Its row source is a value list: 1;Ref ID Ascending;2;Ref ID Descending;3;Date Worked Ascending;4;Date Worked Descending;5;Created Ascending;6;Created Descending;7;Edited Descending;8;Edited Ascending;9;Sequence There is a function to automatically add records to the table and display them. After this function, the user wants the displayed records to sort by 'Sequence'. All works perfectly. Except he wants the combo box to show the word 'Sequence' after adding the records. So I have the following code at the end of the Auto Add function: ' Set sort to Sequence Number Me.OrderBy = "Sequence" Me.OrderByOn = True Me.Requery Me.cboSortBy = "Sequence" but the word Sequence refuses to appear in the combo box no matter what I try. I tried Repaint, .Column(0), .Column(1), changing the bound column - nada. Is it something simple I'm missing her (probably)? MTIA Rocky