Multiple Selected Listbox On Reprot

[alFRed88NSH]

Hi
First of all i'm new to access. I'm making an exam registration system database. In it's candidate table, there's a subjects field which is actually a multiple selection listbox that get's the values from another table. The subjects table has their names and codes.
The problem is that when I want to make a report using the wizard, I see all selected and unselected values in the listbox in the report. I wanna see just the selected subjects with their code.
I think I have to change the query for the listbox in the report. But i'm out of ideas to what to do. If u need I can attach my database file.
and sorry, if it's on the wrong place, I dont exactly know the best place for it.
and I have windows 7 64bit and office 2010 64bit

 

[dhookom]

I don't use multi-value fields. I think you could use a subreport based on the expanded multi-value field.

Duane
Hook'D on Access
MS Access MVP

 

[alFRed88NSH]

Can you explain more? I have no idea about what is it.

 

[dhookom]

Did you use a multi-value field? I don't use them so I would need to create something similar to your setup so that I could help you. Please tell me about your significant tables and fields.

Duane
Hook'D on Access
MS Access MVP