none
Showing selected value of a multi-value lookup field in report RRS feed

  • 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,


    • Edited by kvaziri Thursday, September 24, 2015 1:04 PM
    Thursday, September 24, 2015 1:02 PM

Answers

  • 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.
    • Proposed as answer by André Santo Thursday, September 24, 2015 1:07 PM
    • Edited by .theDBguy Thursday, September 24, 2015 1:08 PM
    • Marked as answer by kvaziri Thursday, September 24, 2015 1:58 PM
    Thursday, September 24, 2015 1:06 PM

All replies

  • 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.
    • Proposed as answer by André Santo Thursday, September 24, 2015 1:07 PM
    • Edited by .theDBguy Thursday, September 24, 2015 1:08 PM
    • Marked as answer by kvaziri Thursday, September 24, 2015 1:58 PM
    Thursday, September 24, 2015 1:06 PM
  • Dear DB guy,

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

    Regards,


    Regards,

    Thursday, September 24, 2015 1:58 PM
  • Congratulations! Glad to hear you got it sorted out. Good luck with your project.
    Thursday, September 24, 2015 3:54 PM