Dlookup help

[jcaptchaos2]

Ok I tried this and it does not seem to be working or at least it is not putting the shift in the table,

Private Sub EmployeeNumber_AfterUpdate()
Shift = DLookup("[Shift]", "[employeelistingjac]", "[EmployeeNumber]= " & [Forms]![Paroll Time on]![EmployeeNumber])
End Sub

[jcaptchaos2]

Sorry it works fine I entered an employee number that wasn't in the employee table so there was no shift
Here is what is working, thanks so much for your help I'm sure I will need it often as I'm taskes to build this database and am just learning

Private Sub EmployeeNumber_AfterUpdate()
Shift = DLookup("[Shift]", "[employeelistingjac]", "[EmployeeNumber]= " & [Forms]![Paroll Time on]![EmployeeNumber])
End Sub

[jcaptchaos2]

One other question now that I'm ready to put this on the shop floor for testing, I know how to get the right form to open when the db is opened but is there a list of everything to turn off so just the opening for pops up and not all the tool bar stuff?