Re: Combo box question
From: Gerben Kessen (gerben.kessen(_at_)wantit.nl)
Date: 08/06/04
- Next message: Diogenes Villarroel \(Hotmail\): "class form or editbox"
- Previous message: twnety0ne_at_yahoo.com: "Combo box question"
- In reply to: twnety0ne_at_yahoo.com: "Combo box question"
- Next in thread: Stefan Wuebbe: "Re: Combo box question"
- Reply: Stefan Wuebbe: "Re: Combo box question"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 6 Aug 2004 22:27:01 +0200
Hi,
You can have multiple columns in a combo box, set
- columncount to 2.
- Rowsource to "table.field1, field2"
- If you don't want to display the id field, set the width of that column to
0; Columnwidth to 250,0 and columnlines to .f.
- Set the boundColumn to '2' if the second column is the id field
The value of the combobox now contains the id of the selected item, so you
can use it in your sql query.
Hth,
Gerben Kessen.
"twnety0ne@yahoo.com" <twnety0neyahoocom@discussions.microsoft.com> wrote in
message news:0458C2F8-D1BF-466E-86D9-2042A20EE37C@microsoft.com...
> How do i assign both the uniqueid and the value from a table to a combo
box?
> Like for example if this is the data in a table
> 1 Blue
> 2 Red
>
> etc
> where 1 is the unique id and Blue is the value, how do i assign 1 as the
> index of the combo box and how do i pass it to a sql query?
Helppppppppppppp
>
>
- Next message: Diogenes Villarroel \(Hotmail\): "class form or editbox"
- Previous message: twnety0ne_at_yahoo.com: "Combo box question"
- In reply to: twnety0ne_at_yahoo.com: "Combo box question"
- Next in thread: Stefan Wuebbe: "Re: Combo box question"
- Reply: Stefan Wuebbe: "Re: Combo box question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
