What report, what control, (seems not to exist a control with that name)?Here is the database. In the report I tried this in the control source of the "Name" field,
= DLookup("[LastName]", "Contacts", _"[JobTitle] = Director"),
Please tell, where you did repost the database?I reposted the Database with the report (Org Chart). I think once you see it you will understand what I'm trying to do. I really appreciate the help!
=DLookUp("[First Name] & ' ' & [Last Name]","Contacts","[Job Title]='" & [Label4].[Caption] & "'")