Environ("Username") problem

[hpl2001]

Hello. I'm trying to insert the NT username of the current user into my database, using the following code:

[User Name] = Environ("Username")

I am getting an error that says 'can't find the field '|' referred to in your expression'

In my table, User Name is defined as a text field.

TIA

Holly

 

[Andrzejek]

Do you have a field (a text box maybe?) on your Form named [User Name] ?

In my table, User Name is defined as a text field.

So it looks like you want to write the Username into a field in your database? If so, what's the WHOLE Update or Insert statement that you have?

Have fun.

---- Andy

 

[hpl2001]

Thank you. That reminded me that I hadn't updated the query with that new field. It works now.

H.