How can a combobox handle record from a database

[fireballs]

Dear Experts,

How can a combobox handle record from a database? when i click the dropdown arrow of the combobox, i want to show the records of the filedname FName.

How can i do this. Please help me! Very Urgent!

My .mdb file is in drive "C:van.mdb" which contains FName as a field name.

 

[nonguru]

Check out this tutorial in vbexplorer

http://www.vbexplorer.com/wrox/sample1061.asp

 

[brittoalexis]

Hai,

Its very easy. You just a declare a recordset and assign the field fhname to the recordset. Then by using the additem method (Using for loop), add each record in the combo box.

Brits

 

[ITweedlie]

Try using a DataCombo component instead of a plain combo box.