Re: Capture Pswrd & Userid To Auto Populate Form

"Nikki Norris" wrote in message:
news:d8a425fa5c104c88ad01e2eeb45b716e@xxxxxxxxxxxxxxxxxxxx

> Hi, the user audience does not have access knowledge. The security is just
> to audit the last person that modified the records. My form will auto
> populate the username field with the locked property set to "yes" so no one
> can change it once in the form. A simple routine is all I need to satisfy
> this requirement.

Ok, sure I have some stuff that can help. It is at the office and I am
heading off to bed now so I will reply back tomorrow with full details.

In the meantime if you want to play around, the short story is to create
a public variable in a standard module that will hold the User Name.
You assign the User Name to the variable right when your authentication
code happens. Then you just reference it when you need to.

> Thanks for your help,

No problem.
--
Jeff Conrad
Access Junkie
Bend, Oregon


.