Docmd.OutPutTo giving me the wrong data

[jwill]

Hello everyone. When I use Docmd.OutPutTo it is giving me the wrong data (see image) 7-18-2014 5-12-08 PM.pdf AND 7-18-2014 5-13-18 PM.pdf



Here is the code

Here is the function

 Public Function export_rpt(var_Rpt_Name As String)
On Error GoTo Err_handler

DoCmd.OutputTo acReport, var_Rpt_Name
 
Exit_export_rpt:
    Exit Function
Err_handler:
    If Err.Number = 2501 Then
        Err.Clear
    Else
        MsgBox "Error number " & Err.Number & ": " & Err.Description
        Resume Exit_export_rpt
    End If
End Function

Here is the call

Private Sub export_lbl_Click()
Call export_rpt(Me.Name) 'features module
End Sub

on the excel spreadsheet the data starts to repeat w/ inaccurate data at the fourth row and I have no idea why. On top of that, when I go to the print preview view in the report and right-click and export that way, I get the correct data . I've already compacted and repaired and I've already transferred objects into a new db. This is an issue that has been going on for about 5 -6 months now. Any suggestions?

[ItsMe]

What type of object do you have open when you are calling the function, form, report?

The object you call the function from has the same name as the object being exported?

[jwill]

The object is the report itself. I click on a label on the report to export it. I just set it up like this so I can reuse it on other reports

[ItsMe]

I would suggest exporting a query object or maybe trying to export another instance of the report. If attempting the latter, suggest simply copying and pasting report object with another name and using the pasted object with new name as object to export.

[AnandKhinvasara]

Its hard to tell whats wrong until you share the db. Check for filters and grouping in report. Check for any property setting changed that shouldnt have.

[jwill]

Sorry for the last response and thanks for your replies...

@itsme - I will try that and let you know

@AnandKhinvasara - The info shows correctly in the report and my export label doesn't change any properties.

This really looks like it may be an Access bug. I don't have a chance to get to it yet, but I will let u all know if I figure it out.