[AccessD] Combo box won't display value

Hi Rocky

I believe you should use:

        Me.cboSortBy = "9"

/gustav

>>> rockysmolin at bchacc.com 05-04-2008 17:04 >>>
 
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