I am very new to making VB applications although I have a fair amount of experience with ASP. I want to populate a dropdown combo box with all the users in my database which is situated in the same directory as the application.

I am unsure of the coding but I would assume that you would have to locate the db like:

App.Path & "\despatcher97.mdb"

and the SQL statement would be as follows:

strSQL = "select * from Users order by Name"

and with my experience with ASP I assume the population part would be something like:

  .MoveFirst
  Do
    Combo1.AddItem .Fields("Username").Value
    Combo1.ItemData(Combo1.NewIndex) = .Fields("Ident").Value
    .MoveNext
  Loop Until .EOF

I am just unsure how you would fit it all together.
Any help with this matter would be greatly received.

With many thanks for your time and assistance,

Paul

sorry i can't help u in these regard

monideep

Hi,

Your script is ok just add WITH..END WITH clause.

Thanks,

Lalit
Life Means More...;)

'Try this
'-------------------------------------------------
'lets say your recordset called "RS"
'--------------------------------------------------

App.Path & "\despatcher97.mdb"

strSQL = "select * from Users order by Name"

with RS

  .MoveFirst
  Do
    Combo1.AddItem .Fields("Username").Value
    Combo1.ItemData(Combo1.NewIndex) = .Fields("Ident").Value
    .MoveNext
  Loop Until .EOF
End With

'happy coding :)