Bound control returns ID rather than value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Civil jenny - 08 Dec 2005 18:17 GMT

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!

Reply to this Message

Marshall Barton - 08 Dec 2005 20:38 GMT

>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message