[AccessD] Combo box won't display value

Yep.  That's it.  I tried 9 before but without the quotes.   

Thanks Gustav.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Saturday, April 05, 2008 8:13 AM
To: accessd at databaseadvisors.com
Subject: Re: [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


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

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.519 / Virus Database: 269.22.6/1360 - Release Date: 4/4/2008
6:02 PM