Showing selected value of a multi-value lookup field in report

Question

I added a multi value lookup field to one of my forms (frmOrder) that get its value from another table (tblMachines) and when I choose multi values in this combo box it works very good in form and show all selected value in the text part of the combo box and it is excellent. The problem arise when I want to show this field in my report. It show only one digit and don't show the selected "machine names". How could I solve this problem?

---

Regards,

Answer 1

Hi. Just change the Textbox control on you report into a Combobox with the same Row Source as the one in your table or form.

Answer 2

Dear DB guy,

Thank you. I changed the RecordSource and column count from 1 to 2 and it solved the problem.

Regards,

---

Regards,

Answer 3

Congratulations! Glad to hear you got it sorted out. Good luck with your project.