Lookup Table not working in my main form

[JM79]

I have my main form which is connected to my main table - Query 1

I have a lookup table (actually a view from SQL Server) which holds my user name - the username used to login to the database- just one value.

In my main form I have a 'Logged By' field. I want this field to default to my login name when I process a record.

I thought it would be as easy as connecting the lookup table to my main form and then in default value typing My_login.user_name.

Apparently not. It just has the #Name? in there.

Anyone have an opinion on this ?

I can use the =environ("username") in the default value which works to good effect but different users use each others PC and I would like the field to be defaulted to thier database login and not thier windows on.

Please help ! It seems so small and its driving me ceeerazy !

 

[ColinEssex]

Its not good practice to have users using each others logins on a PC. Each user should login under their own network ID. or the one who initially logged in gets the blame if anything goes wrong.

Then you can use the Environ("username") easily.

Col