Results 1 to 4 of 4
  1. #1
    Lesg is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    101

    multi select ID variables to print report

    I have a form with a multi select list box for customers and account balances. Using this list box, I want to print statements for all clients selected in the list box upon clicking the print statements button
    Click image for larger version. 

Name:	multi select box.JPG 
Views:	18 
Size:	39.1 KB 
ID:	47643



    I have a report 'rptStatement' that uses the custID to fill the details of the report, so trying to understand how I create an arrary of custID, in the onclick event for each statement if anyone can advise, or point to some guidance.

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,111
    Have you searched the web for some ideas (I used "access list box multi select query criteria)" in Google?
    https://stackoverflow.com/questions/...s-access-query
    https://answers.microsoft.com/en-us/...9-2cd69aa6924a
    https://answers.microsoft.com/en-us/...6-7258ba86dced
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,892
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Lesg is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2021
    Posts
    101
    thanks for those links guys, will take a look and see how I get on, thank you.

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

Similar Threads

  1. Replies: 10
    Last Post: 10-26-2019, 12:15 PM
  2. Multi Select Report Problem
    By aamer in forum Access
    Replies: 7
    Last Post: 12-06-2015, 12:46 AM
  3. Open report from multi-select list box
    By Nadine67 in forum Access
    Replies: 1
    Last Post: 07-22-2015, 06:01 PM
  4. Multi Select Combo box for print function
    By jparker1954 in forum Reports
    Replies: 11
    Last Post: 09-17-2011, 03:08 PM
  5. Combo box to select report to Print
    By usmcgrunt in forum Reports
    Replies: 4
    Last Post: 09-17-2010, 06:44 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