list of database users in drop down

Is there a way to pull a list of all of the SQL database users that have access to a particular database and have them displayed in a drop down menu in a vb program?

Thanks,
Rick

Look at sp_helpuser to get started.

I researched sp_helpuser and I ran into a road block. How do I get one Username at a time?

Thanks for your help,
Rick

My code so far:

Dim oServer As New SQLDMO.SQLServer
Dim oDatabase As SQLDMO.Database

oServer.LoginSecure = True
oServer.Connect "(local)\MyDatabase"

Set oDatabase = oServer.Databases("MyDatabase")

strGetUserName= "exec sp_helpuser"

oDatabase.ExecuteImmediate strGetUserName

Simple example:

rs.Open "EXEC sp_helpuser", conn

Do Until rs.EOF
Debug.Print rs!LoginName
Loop

Would you please expand your code a little and give examples of how rs and conn is used.

Thanks

There are tons of examples on this forum of doing ADO connections and recordsets. That's what the search button is for.