Combo List control

[divined]

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

[RobDog888]

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

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

[divined]

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

[mendhak]

Trim removes leading and trailing blank spaces in the string.

Highlight the word Trim in your code and press F1

[divined]

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!