I have a function in a basic module that is being called from a custom ribbon tag, for which the code reads:
strFileName = SaveFileName(strFileType, strFileType, strFileFilter)
If strFileName <> "" Then
DoCmd.OutputTo acOutputReport, Screen.ActiveReport.Name, strFileType, strFileName
It works beautifully, however I would like the default filename to be something like "FacListNum" & Me.FacListNum, with FacListNum being the name of a control or field on my report. As it is, it uses the name of the report rather than dynamically naming it according to the value of my field or control. Any help would be appreciated.