Passing A Date Range From Form To Report

[JeffGeorge]

I have a form where a user enters a starting date and an ending date. The form also has a button to open a report after putting in these dates. However, I can't seem to get the right syntax for using that date range as the criteria for the Date field on the report (which would link to the Date field of the database). I imagine that this is fairly easy to, and I've probably done it before, but I'm just drawing a complete blank at the moment.

[June7]

Could use a parameterized query.

Or

Use VBA to build the criteria string and pass to the report with WHERE CONDITION of OpenReport, like:

DoCmd.OpenReport "report name", , , "[fieldname] BETWEEN #" & Nz(Me.Start, "1/1/2000") & "# AND #" & Nz(Me.End, "12/31/2900") & "#"

[JeffGeorge]

I don't know anything about VBA so I guess I would have to use a parameterized query. Does the query have to include all of the fields I want to have on the report or just the date filter? Speaking of filters, is there a way to just add a filter to the report so that it only includes the dates that fall within the range on the form?

[June7]

There is macro equivalent for the OpenReport method.

Query must include fields desired for the report. That's what the report RecordSource property is for. The RecordSource can be a table name, query name, or SQL statement.

Report has Filter and FilterOnLoad properties.