Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    1

    Exclamation Unanswered: Multiple Selected Listbox On Reprot

    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

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Welcome to the forum.

    No need to post the whole database, simply post the SQL of the Listbox, the one of the report and an explanation about what criteria should be applied to restrict the range of the items into the listbox.

    I'm not sure you would find many people here (or almost anywhere else) that use the 64 bit version of Office right now (many don't even use Office 2010 32 bits), so loading and opening your database could be a problem if you posted it.
    Have a nice day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •