User Level Security list populates combo box

[Michelle]

Is there a way to get the list of people who have
registered accounts with the User-Level Security to appear
by their user names in a combo box?

Ideally, I would like to have a way to associate a name
with a user-level logon, so any suggestions on how to do
that would be appreciated as well. I want to allow users
to select another user to send email to from a subset-type
list.

Thanks!

 

[Michel Walsh]

Hi,


The Users collection should help you for a start.

===========
Public Sub ListU()
Dim U As User

For Each U In DBEngine(0).Users
Debug.Print U.Name
Next U
End Sub
===========

The user actually connected is CurrentUser.


Hoping it may help,
Vanderghast, Access MVP