In the on the form [employees]![Title] i am using an afterupdate DLookup code to place [Division] and [EmploymentStatus] based on the entry. My problem is NOTHING is happening. No errors, debugging issues, or results populating the fields. I have used DLookup many times but it seems I am missing something. I have used the code both ways listed below with same non-result. Any ideas would be appreciated.
Expand|Select|Wrap|Line Numbers
- division = DLookup("[Division]", "[titleconversion]", "Id= " & Forms!employee!Title)
- EmployeeStatus = DLookup("[EmploymentStatus]", "[titleconverson]", "Id=" & Forms!employee!Title)
- division = DLookup("Division", "titleconversion", "Id= " & Forms!employee!Title)
- EmployeeStatus = DLookup("EmploymentStatus", "titleconverson", "Id=" & Forms!employee!Title)