I have two tables in my database, and a form that is opened when the user logs in.
A text box in this form will display that users name e.g. "Ollie", I want another text box to display this users contracted hours from within the users table when the form is opened.
I have tried using the DLookUp form in the before update section however nothing happens? Below is an example of what I have tried.
So saying that the value in my form text box "Operator" is Ollie, the value in my table column "UserLogin" is Ollie, i'd like another text box on the form to display the contracted hours on the record for Ollie.Code:=DLookUp("[ContractedHours]","tblUser","[Operator] =[tblUser]![UserLogin]")
tblUser contains these columns
My form contains a text box that will equal either Ollie or Ryan, and I would like another text box that displays the relevant Contracted HoursCode:ID UserLogin Contracted Hours Password 1 Ollie 8:00 ***** 2 Ryan 5:00 *****