Results 1 to 5 of 5
  1. #1
    handsomealso is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2013
    Posts
    16

    Printed report based on selected criteria

    I have database which included multiple field such as, place of work, educational level, nationality…
    In the report I want view only the criteria which I selected


    So, I want create form that include all the information I selected ex: in the place of work I want view:

    • Location A
    • Location B
    • Location C
    • Location D


    And in educational level I want view:

    • Master
    • BSC
    • Diploma


    That mean any criteria I selected will appear in report.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    The easiest way to set this up is to have a series of combo boxes or list boxes on a form where you can select the items you want then in the criteria of your query driving your report you'd have:

    forms!formname!fieldname

    as the criteria. So let's say your form is called 'frmReportSetup' and your Place of work field is called 'WorkPlace'

    The criteria in your query would be:

    forms!frmReportSetup!WorkPlace

    This assumes you'll always have a value for those and depending on your level of expertise you may want to create the data source on the fly rather than having a hard coded query.

  3. #3
    handsomealso is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2013
    Posts
    16
    Thank you
    I use combo boxes, but if i change the property of it to be multi select it does not work.
    Because sometimes i need select more than one option.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Selecting multiple items for same field as filter criteria needs listbox and VBA code.

    Review: http://allenbrowne.com/ser-50.html
    Last edited by June7; 04-18-2013 at 09:36 PM.
    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.

  5. #5
    handsomealso is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2013
    Posts
    16
    Thanks
    I will try it

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

Similar Threads

  1. Replies: 3
    Last Post: 05-13-2013, 07:06 PM
  2. Query Criteria Based on Item Selected???
    By P.Malius in forum Queries
    Replies: 5
    Last Post: 04-16-2013, 02:09 AM
  3. Hide button on printed report
    By tylerg11 in forum Reports
    Replies: 5
    Last Post: 12-03-2012, 03:20 PM
  4. Replies: 2
    Last Post: 06-20-2012, 02:21 AM
  5. Replies: 30
    Last Post: 03-01-2011, 10:05 AM

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