gojets1721
Registered User.
- Local time
- Today, 15:00
- Joined
- Jun 11, 2019
- Messages
- 430
In the control source of a field, I am hoping to look up a field in a separate table. Essentially, it's a manager field. I have a table full of manager names and their locations. If the location on the report matches the location in the table, I want that managers name to show up on the report. Here's my code. Access is asking me to input 'me' when i use this code so clearly something is wrong
Code:
=Nz(DLookUp("ManagerName","tblManagers","Location='" & [Me.][Location] & "'"),"")