Combo Boxes

[bon]

Hi!

What is the syntax for loading data to comboboxes and listboxes from the databases.Whenever I use the "additem" it gives me errors.

thanx.

[tdemoy]

Here is a small example with a select in an Access database then, I use the Additem for adding recordds in my list box

'
SQL = "select my_table from my_column where vadm_id = " & AdmId
Set Rs = Db.OpenRecordset(SQL, dbOpenDynaset)
'
Do Until Rs.EOF
ListBox.AddItem Rs![my_description]
Rs.MoveNext
Loop


Good luck,
Thierry Demoy (France)