• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• simple way to access the database and adding to the listbox or combobox Controls

simple way to access the database and adding to the listbox or combobox Controls

simple way to access the database and adding to the listbox or combobox Controls

Rate simple way to access the database and adding to the listbox or combobox Controls

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

---------
function_name(ctl as control,fld as string,tbl as string)
rs.open "select  " & fld & " from " & tbl & " order by " & fld & "", connection,cursortype, lock type
while rs.eof=false
 ctl.additem rs(0)
 rs.movenext
wend

In program
----------
call function_name(combobox1,"field1","table1")
call function_name(combobox2,"field2","table2")
'like thatb u can access whatever u want