Populating a combo box

[MattCollins]

On my form i have a list which takes information from a table. I have set column headers to "on". What i want to do is populate my combo box with the column heads in my list box. Anyone have any ideas?

Cheers,
Matt

 

[gromit]

Hi -

The best thing that I can think of is to have a SQL statement that defines the rowsource for the listbox and then use it to populate the combo box.

E.g.
On FormLoad

Me.lstBox.RowSource = "SELECT field1, field2, field3 FROM datatable"
Me.cmbBox.RowSource = "field1; field2, field3"

[Not quite sure on the syntax for the cmbBox when using the field list.]

Not a great idea, but the best I can think of.

- g