What am I doing wrong: DLookUp

[TanyaM]

I want to have the WorkPhone from my company table display (not available to
edit) in my contacts form (Contacts form is based on contacts table).

So in an unbound box I have the following control source:

=DLookUp("[Company]![WorkPhone]","[Company]","[Company]![CompanyID] =
Forms![CompanyName]")

It doesn't seem to be working. What am I doing wrong?

Thanks,
Tanya

 

[Douglas J. Steele]

Forms![CompanyName] is incorrect. The syntax is
Forms![NameOfForm]![NameOfControl]

Also, remove the [Company]! from in front of [WorkPhone] and [CompanyID]

 

[Damon Heron]

For one thing, you are comparing an ID with a name. Have you tried:

=DLookUp("WorkPhone","Company","CompanyID = " & [CompanyID])

Damon