Bound control returns ID rather than value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top