shows everything in a combo box on the report

[Gaufres]

hi

i have a report linked a query, which is pretty simple one. all fieds appears well but one of them shows everything inside of the combo box.

please see the attachment file called Book List.jpg

for example, item_id, 180, should only show "Testing" in the "Category" filed on the report but it shows all fields - "Testing", "Games", "Vocabulary", "Writing", "Reading", "Speaking", and so on.

i played around on a property of "Category" on the report design view but i am unsure.

how can i show the "Category" on the report that is chosen? or, could anyone give me some key words to search? i googled but perhaps my key words weren't good, i couldn't get good results..

any suggestions?

Gaufres

 

[Pat Hartman]

Your picture is of the recordset created by a query so I don't know what is wrong with your report.

The report should be based on a query that joins the main table to the lookup table. Select the fields you want from the main table and the "text" value from the lookup table. That way, your report will always show the "text" value of the lookup rather than the numeric value.

 

[Gaufres]

can you please tell me what do you mean by the lookup table? "category" is set as "text" as in data type..

my report appears like the attachment. for example, item id 100 should be writing but on the category column, all categories are there.

 

[Gaufres]

sorry forgot to attache a file.

 

[Pat Hartman]

You have used a listbox control on the report rather than a textbox or combo.

 

[Gaufres]

I see! Thank you!