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.
Printable View
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.
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)