[AccessD] A2K: Combo and List boxes sort

Hi Doris
Thanks for the quick reply
I'm a bit embarrassed by that - I never thought it would be that easy. (Says he red faced)

I just assumed it would be Me.listBox.Selected.SomeVagueReferenceSomewhere
or something similar

Many thanks

Have a very merry Christmas

Darren

----- Original Message ----- 
From: "Mike & Doris Manning" <mikedorism at adelphia.net>
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Sent: Wednesday, December 24, 2003 11:49 PM
Subject: RE: [AccessD] A2K: Combo and List boxes sort


> Assuming that ProductID is the bound column in both controls:
> 
> lstProducts = cboProducts
> 
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
> Sent: Wednesday, December 24, 2003 7:28 AM
> To: AccessD List
> Subject: [AccessD] A2K: Combo and List boxes sort
> 
> 
> Hello all
> Merry Christmas to all
> Yes I know I shouldn't be working but what can I say? :-(((
> 
> I have a combo filled with say... tblProducts
> on the same form I have a list box also filled with say...tbProducts
> 
> What syntax do I need to get the list box to highlight the same value from
> the combo
> 
> EG User selects Product ID 25 from the combo
> How do I get the list box to find then highlight Product ID 25?
> 
> Many thanks in advance
>  
> And again a very very merry Christmas to all
> 
> Darren
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com