Bound control returns ID rather than value

[Guest]

Please help.

I have 2 tables: the 1st one contains a field named "Subject Area" with a
combo box listing values in the 2nd table (which has only the subject ID and
the subject names). I created a report based on the 1st table with a bound
textbox for the Subject Area field. The problem is the textbox shows the
subject ID rather than the value. How can I solve this problem?

Thanks!

 

[Marshall Barton]

I have 2 tables: the 1st one contains a field named "Subject Area" with a
combo box listing values in the 2nd table (which has only the subject ID and
the subject names). I created a report based on the 1st table with a bound
textbox for the Subject Area field. The problem is the textbox shows the
subject ID rather than the value. How can I solve this problem?

The report's record source query need to Join the two tables
so the text box can be bound to the subject name field.