Results 1 to 3 of 3
  1. #1
    Bozer is offline Novice
    Windows XP Access 2007
    Join Date
    May 2023
    Posts
    5

    Problem with report from Sub Form

    Good morning all,


    After a little help, I have a form with tabbed pages and on my final tab I have a Sub Report/form, this form works perfectly filtering to show only what I want from the main form and query.
    But I have created a separate report for this Sub report/form filtered data and this shows the data correctly but it shows all data instead of the filtered data shown in the Sub form.
    I have tried loads of stuff but nothing is working for me.

    Thanks in advance

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Well you need to use the same filter as for that on your form?
    So pass that as the filter to the OpenReport statement.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Bozer is offline Novice
    Windows XP Access 2007
    Join Date
    May 2023
    Posts
    5
    Thanks for the reply but I got it in the end

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

Similar Threads

  1. Replies: 9
    Last Post: 07-02-2022, 08:08 PM
  2. Replies: 3
    Last Post: 06-09-2019, 10:45 AM
  3. Problem passing line total from sub report to report
    By tbjmobile@gmail.com in forum Reports
    Replies: 9
    Last Post: 02-19-2018, 04:31 AM
  4. report problem
    By mann2x in forum Reports
    Replies: 1
    Last Post: 10-09-2010, 06:10 PM
  5. Replies: 2
    Last Post: 06-14-2010, 03:25 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