diannebcgray
New member
- Local time
- Today, 06:40
- Joined
- Aug 9, 2022
- Messages
- 13
Hi,
I am stumped out of my mind. I am trying to use a form control value in the simplest way possible in a report. I have a form as shown below, where a date range determines query values that are displayed in a report as pie and bar charts.
When you click Generate Report, this is the code:
I would like to pass on the above text boxes textStartDate and txtEndDate box values into labels in my report (for example, into chart titles and labels for report titles). I'm not having much luck. What's the easiest way to do this?
I am stumped out of my mind. I am trying to use a form control value in the simplest way possible in a report. I have a form as shown below, where a date range determines query values that are displayed in a report as pie and bar charts.
When you click Generate Report, this is the code:
Code:
Private Sub btnGenerateReport_Click()
DoCmd.OpenReport "Custom Report", acViewPreview
End Sub
I would like to pass on the above text boxes textStartDate and txtEndDate box values into labels in my report (for example, into chart titles and labels for report titles). I'm not having much luck. What's the easiest way to do this?