Combo Box Help

[Hollie]

Hi,

any help with the following would be great!

I have a combo box that gets it values from a table on SQL Server 7 through an ADO connection and Data Environment.

Problem is - it only returns the first item in the table.

Why? Help!

H.

[Aaron Young]

Are you using a Standard Combobox and Expecting it to fill the Drop List with the values from the Table?

If so you'd have to recurse the Recordset/Table manually filling the Combobox, alternatively use the DataCombo control. (Available from the Microsoft DataList Controls Component.)

It has a RowSource property for binding data to the List portion of the control as well as the control value itself.

[Hollie]

Thanks for the help. It's now working

H.