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?
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?