Results 1 to 2 of 2
  1. #1
    OverPlayed is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2018
    Posts
    6

    Print Report from filtered datasheet on Sub-form

    Hello,



    I have a simple database that is tracking tickets we open with our developers.

    I am trying to create a report that will contain data from a filtered sub-form.

    Basically I want to be able to filter the sub-form datasheet and then print those results in a report.

    The data sheet contains 7 columns and 44 rows so it is not a large report.

    Thanks for any help provided!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Apply the same filter criteria to the report using the WHERE CONDITION argument of OpenReport.
    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.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-21-2015, 11:35 PM
  2. Replies: 2
    Last Post: 07-28-2014, 01:15 PM
  3. Form with pivot + filtered datasheet
    By kwag in forum Forms
    Replies: 5
    Last Post: 03-03-2014, 04:26 PM
  4. Filtered Report from filtered datasheet form
    By gemadan96 in forum Reports
    Replies: 7
    Last Post: 01-03-2014, 05:12 PM
  5. Replies: 1
    Last Post: 12-03-2012, 03:15 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