hi there..

i think you have a problem with your recordset, probably bringing the wrong
set of records...

can you post how you make your recordset??

Gonzalo Martin Bianchi
Desarrollo de sistemas de cuenta corriente tributaria
Hipolito Yrigoyen 370
Entrepiso B pasillo 600 oficina 5
4347-3181
----- Original Message -----
From: <gail711@g...>
To: "professional vb" <pro_vb@p...>
Sent: Thursday, October 17, 2002 4:18 PM
Subject: [pro_vb] Re: Combo fill question


> I know how to fill the box for the drop down bit, use following code -
>   With rsSchCmb
>      .MoveFirst
>            Do Until .EOF
>             strItemText = CStr(rsSchCmb.Fields("unitname"))
>             School.cmbMealOut3Schl.AddItem strItemText
>             .MoveNext
>           Loop
>     End With
> it's the bound column/data field part i'm having trouble with.  I want the
> combo box to show the school name that corresponds to the UnitID specified
> in the SchTrans field, at the minute all i can get it to do is show the id
> number.
> e.g  my table hold details similar to this
>
> UnitID    SchoolName         SchTrans
>   1       Academy One         3
>   2       Academy Two         3
>   3       Academy Three       1
>
> So, my combo box should read Academy Three for the first two records and
> academy One for the last.  I have it saying 3 and 1, i can't get it to
> take the school name.
>
> Does that make more sense?
>
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
>