Results 1 to 3 of 3
  1. #1
    tmartin is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    37

    Report output replicates 3 times when launched from FORM

    The Daily Employee Form when manually launched the output is fine. Only 1 page is displayed or printed. When I launch the Report from a Form, the output is replicated 3 times. I am launching other reports from a FORM without any problems. Not sure why its doing it.



    The data in the database must have the current date to display content in the form. If you run testData you can move previous data to the current data so its populated when you run FORM1.

    I would really would like to know why this is happening.

    Thanks
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Opening from the button opens in Report View. Manually opening the report opens in Print Preview - still shows the same data in triplicate.

    The main report is bound to [Daily Turn Today Query] which has 3 records for employee ID 24. The subreports are in the Detail section which means they will display with each record of the main report. Perhaps they should be placed into the EmployeeID group header or footer.
    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.

  3. #3
    tmartin is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    37
    There should have been only 1 report for a single person for that day. Playing around had corrupted the database during development. Thanks for the insight.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-23-2014, 04:35 PM
  2. Replies: 2
    Last Post: 03-18-2013, 03:03 PM
  3. Combo box replicates it's data
    By 107295 in forum Forms
    Replies: 1
    Last Post: 02-08-2011, 05:57 AM
  4. Query doesn't work when launched by code
    By stephenaa5 in forum Queries
    Replies: 1
    Last Post: 10-24-2009, 09:52 AM
  5. Making the launched form seperate from Access
    By MonsterMaxx in forum Access
    Replies: 1
    Last Post: 09-06-2009, 12:11 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