Results 1 to 4 of 4
  1. #1
    SgtSaunders69 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    17

    Multi-selection from list box to reports

    I'm trying to adapt the code shown on this website http://allenbrowne.com/ser-50.html (code attached) to my database to enable me to send multiple selections from a list box to whichever report I chose to run. The report to be used is selected from a combo box. The selection in this combo box goes to the code embedded in the click event on the button on the form. My problem seems to be that this code is designed to have the reportname embedded in the strDoc = "Products by Category" line. I'd like to be able to have this line pointed at the combo box, but that doesn't seem to be possible (give my coding limitations). Can someone advise on how to accomplish this?
    Thanks...
    Attached Files Attached Files

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    As answered elsewhere

    strDoc = Me.ComboName

    or

    DoCmd.OpenReport Me.ComboName,...
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    SgtSaunders69 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    17
    Yeah baby... worked great.... thanks!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-29-2014, 09:58 PM
  2. Multi select list box
    By foxtet in forum Forms
    Replies: 1
    Last Post: 05-30-2011, 02:13 PM
  3. Replies: 8
    Last Post: 12-22-2010, 08:12 AM
  4. Multi-Selection Option?
    By jlclark4 in forum Forms
    Replies: 4
    Last Post: 12-15-2010, 08:23 AM
  5. Replies: 1
    Last Post: 03-09-2006, 12:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums