Report and SubReport keep asking for data input

  • Thread starter Thread starter korgman
  • Start date Start date
K

korgman

Hello there,

First time that I post here, please *excuse me*: my english are NOT good.

I have created a Report based on a query that asks for specific date in
criteria with this option: [Date?]

Also I have "attached" two subreports.

So, when I open the Report automatically opens a dialog box and waits for me
to type the desired date. (ok, this is normal)

But it keeps asking me for the [Date?] three times. I suppose one time for
each report and subreport. When I change page again it asks 2 times for the
[Date?] (I suppose each time for one subreport).

This is strange to me, because when I design a Query wich is related to
another Query with the same parameter [Date?] (and in the same field of
course) Access automaticaly stores the number from the "first" Query and
don't asks again for the [Date?] in the "second" Query. This is very
convenient and.. logical.

But in reports it does NOT work like this?

Weird

I managed two make two queries with only in "first" to have the parameter
function [Date?], and the related "second" query does NOT have any
parameter, it's empty in criteria.

Again the same problem :-(

I suppose that only with programming I can manage this problem?

Can I post .png images here?

Thank you!
 
Stop using parameter queries. Use a reference to a control on a form. Create
a form "frmDates" with a text box "txtDate" and then change your criteria
from [Date?] to:
Forms!frmDates!txtDate
Make sure the form is open with a value in the text box and then run your
report.

Parameter queries are for quick and dirty, uncontrolled, limited
functionality, unbridled usage.
 
Yes master!

Allready Done!

Allthough I have a book I never undestood that the parameter Queries are not
"good".

Thank you! You are like a dream, extremely fast response! :-)

Duane Hookom said:
Stop using parameter queries. Use a reference to a control on a form. Create
a form "frmDates" with a text box "txtDate" and then change your criteria
from [Date?] to:
Forms!frmDates!txtDate
Make sure the form is open with a value in the text box and then run your
report.

Parameter queries are for quick and dirty, uncontrolled, limited
functionality, unbridled usage.

--
Duane Hookom
MS Access MVP
--

korgman said:
Hello there,

First time that I post here, please *excuse me*: my english are NOT good.

I have created a Report based on a query that asks for specific date in
criteria with this option: [Date?]

Also I have "attached" two subreports.

So, when I open the Report automatically opens a dialog box and waits
Click to expand...
for
me
to type the desired date. (ok, this is normal)

But it keeps asking me for the [Date?] three times. I suppose one time for
each report and subreport. When I change page again it asks 2 times for the
[Date?] (I suppose each time for one subreport).

This is strange to me, because when I design a Query wich is related to
another Query with the same parameter [Date?] (and in the same field of
course) Access automaticaly stores the number from the "first" Query and
don't asks again for the [Date?] in the "second" Query. This is very
convenient and.. logical.

But in reports it does NOT work like this?

Weird

I managed two make two queries with only in "first" to have the parameter
function [Date?], and the related "second" query does NOT have any
parameter, it's empty in criteria.

Again the same problem :-(

I suppose that only with programming I can manage this problem?

Can I post .png images here?

Thank you!
Click to expand...
Click to expand...
 
Back
Top