How do i populate dropdown box on basis of the query written in vb.
i am using access forms.

here is the code
thanks in advance.

Dim abc As String
Dim db As ADODB.connection
Set db = New ADODB.connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
'Make Connection with the Database.
connstr = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=CVTracker;Initial Catalog=CVTracker"
db.Open (connstr)
Sql = "Select * From ContactDetails where UserID =" & Form_frmMain.ID
Set rs = db.Execute(Sql)

While Not rs.EOF

-------Some Code Requried here s the code i am missing something in while loop.
how to achieve this.
-----

    rs.MoveNext
Wend


Best Regards,
Vivek.

__________________
Best Regards,
Vivek.

Why are you using code to populate this combo box?
If the data is in another database, a better solution might be to transfer the data into a temporary table in the local database, and then have the combo box get data from the local table.



mmcdonal

dropdown should display only those dtata which are related to memeber who as logged in.




Best Regards,
Vivek.

 dropdown should display only those dtata which are related to memeber who as logged in.



Best Regards,
Vivek.