I have a report I am opening in VBA, and the report happens to be based off of a query that has two parameters (Start Date, and End Date). I am attempting to open the report with two variables I am sending via VBA.
So far I have attempted...
Code:
strSDate = txtReportStartDate.Value
strSDate = "Start Date = #" & txtReportEndDate.TEXT & "#"
DoCmd.OpenReport "SUMMARY", acViewPreview, strSDate
I know this is only attempting to send one parameter, but I have no idea how to send two. But the report seems to ignore what's being sent anyway, and still prompts me for the start date.
Any help would be appreciated. Thanks!