Access Default Value Problem

[Boots6]

I have an RFI and a Contacts table. I have an RFI form that has "To" and "From" look up fields connected back to my Contacts table. I am trying to add Title, Address, etc fields for the "To" and "From" fields using the Default Value property. I have created a text box with the Control Source set to "From" and I put the Default Value property to =[CONTACTS]![D_TITLE] but the box only shows the Contact ID for the record, not the title. What am I doing wrong?

 

[SkipVought]

forum702

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}