LysaTigger
Technical User
Hi,
I have a syntax error and I don't know how to fix it.
I am trying to filter a report based on a date range.
Here is the code that I have attributed to a cmdbutton in a form to filter the report based on a date range.
DoCmd.OpenReport "rptRequestDate", acViewPreview, , "[StartDate] >= #" & Me![txtFromDate] & #" and <= #" & Me![txtToDate] & "#"
Please let me know where the syntax error is.
Thanks,
Lysa
I have a syntax error and I don't know how to fix it.
I am trying to filter a report based on a date range.
Here is the code that I have attributed to a cmdbutton in a form to filter the report based on a date range.
DoCmd.OpenReport "rptRequestDate", acViewPreview, , "[StartDate] >= #" & Me![txtFromDate] & #" and <= #" & Me![txtToDate] & "#"
Please let me know where the syntax error is.
Thanks,
Lysa