combo box thats able to link to Active Directory??????

[DJDOHBOY]

Is it possible to create a cobmo box/dropdown list that gets its list
of information dymanically from active directory?

I have a database with a "Staff" field, and was wondering if there was
a way of getting the drop down box to get the list of all users in a
specific OU? this would be a major time savor and help reduce dirty
data. (as im really bad at remembering to add new members of staff to
the call logging database lol)

Many thanks in advance

Regards

John

[engles]

On Apr 20, 4:32 am, DJDOHBOY <[e-mail]:

Is it possible to create a cobmo box/dropdown list that gets its list
of information dymanically from active directory?

I have a database with a "Staff" field, and was wondering if there was
a way of getting the drop down box to get the list of all users in a
specific OU? this would be a major time savor and help reduce dirty
data. (as im really bad at remembering to add new members of staff to
the call logging database lol)

Many thanks in advance

Regards

John

Look up the DIR function. From it, you should be able to solve your
problem. I would tend to write code that runs only when the
application opens that looks for new staff and adds them to a local
table. If the application is never closed, then you would need some
other approach.
-- Larry Engles
Access developer since day 1 of Access 1.0