Jenn,
It's no big deal, but...please don't start another thread with the same question.
Others may not realize what's been covered before, and duplicate replies and efforts.
If you look at your previous post, at John Vinson's last answer... that would be the
best way to go.
[Quoted Text] > I'd put it in the DefaultValue property of the form textbox into which
> you wish the employee name to be entered.
Place this in the DefaultValue for the UserName field...
=[CurrentUser]
Any time a new record is created, the users signon will be filled in.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
"JennBard1" <JennBard1[ at ]discussions.microsoft.com> wrote in message
news:9FB2A2CE-1E42-4724-B703-7E80AEA81DD8[ at ]microsoft.com...
> thanks for the help on my question on how to get the employee name to
> automatically come up after loging in using the statement that you ave me
> below:
>
> EmployeeName = CurrentUser()
> using the builtin function?
> Where do I put this, in the table or form and what heading do i put it
> under. I tried to put it in the table under the default value but it keeps
> giving me error messages
>
> The error message that i get is :
> "Unknown function 'CurrentUser' in validation expression or default value on
> 'Apollo Purchase Orders.EmployeeName'."
>
> Am i missing something, do i need to specifically tell it where to pull the
> employee name from.
|