Passing Query Prompt to Report

[PBISMaryland]

Hello.

I am using Access 2007 and need some assistance with a report. The report
is based on a select query that prompts for a date range. In the report is a
graph that is also associated with the same query. The graph changes based
on the dates selected. When the report is run the user is prompted to enter
the date ranges twice. I think I understand why....because the query is
called once for the main report and once for the graph. What do I need to do
to avoid being prompted twice. SIDE NOTE: I can avoid the duplicate prompts
by removing the Record Source for the main report but I want to be able to
include the values of the entered prompts in the report itself and only know
how to do that by including the query in the Record Source.) I feel like I
have gone full circle.

Thanks for your time.

 

[Duane Hookom]

IMHO, parameter prompts are never good user interface
http://www.tek-tips.com/faqs.cfm?fid=6763.

If you use controls on a form, you can add a text box with a control source
like:
=Forms!frmDates!txtStartDate

 

[rahmad]

Last time,
I change that 'select query' to 'make table'query.Then my report is based
the second query that comes from the table of make table query.So I'm
just prompted when run my make table query.