I have a report that as a variable [BalReason] in it so that when the report is opened it prompts the user for input that is added in to the report. I would like to now have the input box that the user enters text and then that text is added to the report.
I need this so I can process that input in various ways beside just the report.
Is this possible?
I tried this as a test but it didn't work:
Dim BalReason As String
BalReason = "TEST"
DoCmd.OpenReport "RBillPatientLetter", acViewPreview, , BalReason