How to reference in a text box 2 fields from another table?

By eckardtk ·

I have two forms where I like to display the contact name for the current record prominently in the upper right hand corner of the form.

The first form is the Contacts Form which is based on the table Contacts. In that case it works; i.e. I created an unbound text box and entered into the text box the following: =[Last]&?, ?&[First]

The other form - Form Call Log - is based on the table Call_Log which in turn is linked to the table Contacts with ContactID as Foreign Key. It is in this situation where the reference data are conained in a different (but linked)table where I have problems. I also created a text box. Then, I tried to type into the text box:

(a) =[Last]&?, ?&[First]
(b) =[tbl_Contacts].[Last]&?, ?&[tbl_Contacts].[First]

Neither (a) nor (b) works. In both cases I get an error: #Name?

What am I doing wrong?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums