Form title dlookup problem

[zoinnk]

I have what I think should be a simple dlookup for a form title, but for some reason it does not work for me.

I have two tables: tblCompany (main table) and tblContacts. The one-to-many relationship is established with a lookup field in tblContacts called Employer (that holds the Company_ID key but displays the value of CompanyName in tblCompany).

The simple thing I'm trying to do is display the CompanyName value in a textbox in a form that filters for a single company. The closest I can get is displaying the Company_ID key (by simply setting the source to the Employer field). If I try to do the below dlookup, I simply get a #NAME error that I can't fix.



=DLookUp([tblCompany]![CompanyName],[tblCompany],[tblCompany]![Company_ID]=[Employer])

Does anyone have any suggestions? Thanks.

[RuralGuy]

*All* arguments to the Domain finctions are strings! http://access.mvps.org/access/general/gen0018.htm

[zoinnk]

Thanks! That was easy.

[RuralGuy]

Glad we could help.