also hasn't responded to my second point. But seems to me the solution suggested by June to use a form to enter the dates is the solution. Modify your query to get the parameters from the form or modify your openreport to include the values as a filter
If you really want to set this data on the fly and unvalidated then use input boxes to capture the data - something like this air code (not tested)
Code:
Dim dStart As String
Dim dEnd As String
Dim stDocName As String
Dim EndDate1 As String
dstart=inputbox("Enter Start Date")
dend=inputbox("Enter End Date")
EndDate1 = dstart & " and " & dend
strPath = "C:\Users\MyName\OneDrive\Documents\FCREA\"
strFileName = "All FCREA Paid Members between " & EndDate1 & ".pdf"
stDocName = "rptSpecificDateRangePayments"
DoCmd.OpenReport stDocName, acViewReport, , "Between #" & dstart & "# AND #" & dend & "#", acNormal
DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, strPath & strFileName, True, "", , acExportQualityPrint
DoCmd.Close stDocName