Hello all
First of all, I hope to learn and help - within my knowledge - whenever I can here in this forum.
Secondly, I assume myself as a "newbie" in Access because I know Access, I just haven't used almost since I've left college (looooong time ago).
So here's the deal: I'm making a very simple db to register employees time relative to the projects they work during the day.
I have a table with the employees info tblEmployee (ID, Name, email, username, password), a table with the projects info tblProjects (ID, name)and a table tblRecord (ID, EmployeeName, Project, Date, nr_hours) with the records itself. Very few little fields for now.
I've made a form based on the tblRecord and I've managed to get the projects table information to be well selected for a proper register.
The problem relies on the employee name. I'll explain:
I've made a small login form with username and password and I can fairly pass the username info through the Register form so that when that user registers a new record his name (EmployeeName) is already filled. Problem: despite the form has all the info to record in tblRecord, the name is blank. I've turned my head around and I cannot see the probelm. If I let the textbox available - write in it - it records fine. If I let that text box with a value that comes from login - view only - The record of the name is blank.
Might be something completely stupid but honestrly...I'm blocked!
Any help would be great.
Thanks in advance