List Box display ID no in Target Field instead of Data

[Bradon]

I have 2 tables, Comments holding 6 comment banks of 10 rows and Student Data which holds 6 columns designated to receive the comment highlighted in the listbox.

The listbox works correctly in transmitting details of the data selected but displays the ID number of the row holding the data from the related table and not the actual data as required.

Any suggestions?

 

[Ziggy]

In the design of the table select the field with the lookup and select the "Lookup tab" on the lower left. Here are the specs for what is displayed and what goes into the field.

Ziggy

 

[Bradon]

Thanks Ziggy,

I am a bit puzzled - the box shows the field set as a text box with no options showing. When I change it to a list box I get the following showing:
Display: List Box
Row Source: Table/Query
Bound Column: 1
Column Count: 1
Column Heads: No

I am completely lost as to what goes where. Data originates from a table called "Comments" and the field I want to display it in is in a table called "Student Data"

Any Suggestions?

 

[Ziggy]

You did do all this with the Lookup wizard right?

There should be something in the "Row Source" like:

SELECT DISTINCTROW [tblComments].[Comment] FROM [tblComments];

If the wizard puts in the ID you can edit the statement to put in the field you want to display.

The "Row source type" would show: Table/Query (don't get confused between the 2)

Ziggy