Why is it Null?

Gorio

Registered User.
Local time
Today, 16:34
Joined
Sep 26, 2000
Messages
33
I've come a long way on Access 97 in a few days thanks to all here. Now I have another problem.

I have a form based on a table of Vehicles. The header of the form states who is using the program. This is shown on an unbound field "User" and comes from the table LogOn.

I need to assign the User name from the header to the Shop in it's "ISBy" field. I've tried equating the two in a variety of ways, but it shows that the "User" field is Null. As a check I placed a message box to print out the contents of the User box and it also shows Null.

Any ideas where I am going wrong?
 

Users who are viewing this thread

Back
Top Bottom