Bound control returns ID rather than value

C

Civil jenny

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!
 
M

Marshall Barton

Civil said:
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?
Click to expand...


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