The code here will get the user's windows name:

http://www.mvps.org/access/api/api0008.htm

But you can't prevent users from browsing what's in the tables unless you add
security features. Put the data in SQL Server tables, where you can
administer security. The express version is free.

Chris
Microsoft MVP


SF wrote:
>Hi,
>
>I was assign to develop an Admin Forms database for my office. It consists
>of 20 or more form. Our HR personel adviced us not to allow browsing staff
>information. Is there a way to capture login name of the current user from
>AD? I want to bing this login name to the name of staff sothat staff who
>uses the form can only select their own name (I want to restirct this
>because if user can browse other staff name he/she can see the remaining
>balance of the medical allowance, education of the other.).
>
>TIA
>
>SF

--
Message posted via http://www.accessmonster.com