On Jul 23, 7:09*pm, "SF" <x...@yahoo.com> 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

this does it. You can filter the form in the open event to filter for
the user's NT Login ID.
http://www.mvps.org/access/api/api0008.htm