Report not saved for current file but for all records

[MrDummy]

Hello,



I have a custom ribbon with below Code attached to a button. I also have a Navigation Form with multiple tabs. When I click the button it activates the FileSaveAsDialog for the current file on the tab and the filename is correct. After clicking "Save" it does not save just the current record it saves all the records into one file.

How to save only the current file? Any help would be appreciated.

    Application.FileDialog(msoFileDialogSaveAs).InitialFileName = "UN" & Format(UNNO, "0000") & ".pdf"
      
    intChoice = Application.FileDialog(msoFileDialogSaveAs).Show
                    
    If intChoice <> 0 Then
   
    DoCmd.OutputTo acOutputReport, "rptUNLookUp", acFormatPDF, "UN" & Format(UNNO, "0000") & ".pdf"
    
    End If

[ranman256]

your query that runs the report needs to pull only 1 record.
I use a form for users to select what they need filtered, ie., select the clientID from a combo box.
the query will not pull only that data...

select * from table where clientID = forms!frmRpts!cboClient

[MrDummy]

OK thank you. The form is already based on a query and is on in of the tabs. It is a "Record Look up" form.
The issue here is that when I use the Code with a button on the Tab itself (so basically when i make it part of the form) the code works perfectly. So it saves only the current record that is visible in the form. But I moved the button to my own Customized Ribbon and now it saves all instead of the current record.
So for some reason it has lost track of the current record that is displayed.

[ranman256]

Does the query use the FULL path to the form?.....forms!frmRpt!txtboxID

[MrDummy]

Hello,

It seems that for some reason the Me.MMDGF doesn’t do what I expected it to do. It loses the ID-number and instead saves all the records. Alternative is shown in below Hyperlink. This does the trick.
Thanks for the replies.

https://bytes.com/topic/access/answe...here-condition