Parameter Pop Up Form with Date Range

[Robbie Doo]

I have created a Pop Up form with Date Criteria. However, the Criteria is in
the RecordSource for each text box. Is there a way where the user can input
their own date range to retrieve information?

Thank you in advance.

 

[Allen Browne]

You will need a form with *unbound* text boxes so the user can enter their
limiting critiera.

Here's 2 ways to do that:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

 

[Robbie Doo]

Thank you Allen for a cool code. However, it doesn't work for charts. I get
the following Run-Time Error '2491'

The action or method is invalid because the form or report isn't bound to a
table or query

 

[Allen Browne]

Which approach did you use: method 1 or method 2?

If 2, which line generates this error?

Does the report have anything in its RecordSource property?

 

[Robbie Doo]

I used the method 2 and the line that generates the error is:

DoCmd.OpenReport strReport, acViewPreview, , strWhere

No, the Chart that is pulled from a query does not have any recordsource
except for when I click on the graph itself it gives me the rawsource where
the information comes from.

 

[Allen Browne]

Ah: the *report* has no recordsource.
The report contains a graph that has a RowSource.

Since the report itself is not bound to a query, you cannot apply a filter
to it. You will need to use Method 1: the parameter query.

If you want to tie that to a form where you enter the dates, create a form
with 2 unbound text boxes named txtStartDate and txtEndDate. Save the form
as (say) "ReportCriteria".

Now create the query to use as the RowSource for the graph.
In this query, include critera like this under the date field:
Between [Forms].[ReportCriteria].[txtStartDate] And
[Forms].[ReportCriteria].[txtEndDate]

Open the report in design view, and use this query as the RowSource for the
graph object.

 

[Robbie Doo]

Thank you Allen. It worked like a charm.

Ah: the *report* has no recordsource.
The report contains a graph that has a RowSource.

Since the report itself is not bound to a query, you cannot apply a filter
to it. You will need to use Method 1: the parameter query.

If you want to tie that to a form where you enter the dates, create a form
with 2 unbound text boxes named txtStartDate and txtEndDate. Save the form
as (say) "ReportCriteria".

Now create the query to use as the RowSource for the graph.
In this query, include critera like this under the date field:
Between [Forms].[ReportCriteria].[txtStartDate] And
[Forms].[ReportCriteria].[txtEndDate]

Open the report in design view, and use this query as the RowSource for the
graph object.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I used the method 2 and the line that generates the error is:

DoCmd.OpenReport strReport, acViewPreview, , strWhere

No, the Chart that is pulled from a query does not have any recordsource
except for when I click on the graph itself it gives me the rawsource
where
the information comes from.