Combo List control

Hello everybody

Can anyone point me to a link on how to use a combo list control?

I want an unbounded combo list which will be populated from a table of a database. The combo list should be populated with a descriptive field, which the user will use to make his/her selection. When the descriptive field is selected a code field should be returned.
Hope I didn`t baffle you guys with all the details!

thx, in advance

George Papadopoulos

Loop through your rs ading items to the cbo.
Something like this

VB Code:

Private sub command1_click()
 
    do while rs.eof = false
        combo1.additem trim$(rs.fields(0).value) & vbnullstring
        combo1.itemdata = rs.fileds(1).value 'must be a numeric value
                                             '.ItemData is like a tag field on other controls.
        rs.movenext
    loop
 
end sub

Not sure what you mean by code filed but this should get you started.

HTH

ok. thx. but what does the Trim function do? Does it trim the string to the components on screen dimensions?

Trim removes leading and trailing blank spaces in the string.

Highlight the word Trim in your code and press F1

Is it compulsory to enter the itemdata property of the component? That is because I have no Integer field in my table. The primary key is a unique alphanumeric string I construct!