Results 1 to 2 of 2
  1. #1
    keaccesshelp is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    1

    Microsoft Access 2010 - Filtered report?

    Hi there,



    I am working on a database in Access 2010.

    I am trying to create a report that appears once a specific combo box is filled out for a particular field in the form I am working in. Basically, when a value is put in the combo box, the combo box will filter the form for all the records that match the criteria in the combo box. The filtered records should then populate into the report that appears.

    The reason why I need this report is because I would like to be able to view all the of the particular records and be able to sort for various fields more efficiently.
    Please help me with this problem.

    If you can solve this I would really appreciate it!

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

    This would be one way to open the report restricted to the appropriate records:

    http://www.baldyweb.com/wherecondition.htm
    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: 1
    Last Post: 09-13-2011, 01:52 PM
  2. Replies: 1
    Last Post: 05-05-2011, 02:54 AM
  3. Replies: 2
    Last Post: 01-15-2011, 10:56 AM
  4. Microsoft Access 2007 - 2010 Compatibility
    By AccessFreak in forum Forms
    Replies: 4
    Last Post: 01-05-2011, 07:57 PM
  5. Filtered Report
    By Desstro in forum Reports
    Replies: 3
    Last Post: 06-18-2010, 09:09 AM

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
  •  
Other Forums: Microsoft Office Forums