[AccessD] Combo box won't display value

Rocky ,

Have you tried it with a final semicolon?  ...;sequence;

Just a thought.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Saturday, April 05, 2008 11:04 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Combo box won't display value

 
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
 

 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com