T
trekgoes2malaysia
I want to avoid having the parameters dialog box appear each time I
open a filtered form. The value from the filter comes from a field on
another form which I have referred to in the Criteria Row of the query
(see below). So, for example, when I select a user name from a list
box on an intial form then click on a control, a subroutine linked to
the control opens another form containing 3 graphs, each of which is
filtered by the selected user name to show only information for that
user. For some reason , the first form worked well and the parameters
dialog box did not pop up (it filtered automatically). However, on
other similar forms (i.e. a copy), the parameter box appears, one for
each graph. How can I prevent this from happening? I'e checked the
code and properties listing and can't figure out what's different
about the two that causes the parameters box to appear on one and not
the other. I've included the xtab query of one of the graphs below.
PARAMETERS [Forms]![MasterGraph]![Getathlete] Text ( 255 );
TRANSFORM Sum([Activity Summary By Week].[SumOfDistance]) AS
SumOfSumOfDistance
SELECT [Activity Summary By Week].[Activity]
FROM [Activity Summary By Week]
WHERE ((([Activity Summary By Week].[Athlete])=[Forms]![MasterGraph]!
[Getathlete]))
GROUP BY [Activity Summary By Week].[Activity], [Activity Summary By
Week].[Athlete], [Activity Summary By Week].[Athleteid]
ORDER BY [Activity Summary By Week].[Activity], [Activity Summary By
Week].[Athleteid]
PIVOT [Activity Summary By Week].[weekrange];
open a filtered form. The value from the filter comes from a field on
another form which I have referred to in the Criteria Row of the query
(see below). So, for example, when I select a user name from a list
box on an intial form then click on a control, a subroutine linked to
the control opens another form containing 3 graphs, each of which is
filtered by the selected user name to show only information for that
user. For some reason , the first form worked well and the parameters
dialog box did not pop up (it filtered automatically). However, on
other similar forms (i.e. a copy), the parameter box appears, one for
each graph. How can I prevent this from happening? I'e checked the
code and properties listing and can't figure out what's different
about the two that causes the parameters box to appear on one and not
the other. I've included the xtab query of one of the graphs below.
PARAMETERS [Forms]![MasterGraph]![Getathlete] Text ( 255 );
TRANSFORM Sum([Activity Summary By Week].[SumOfDistance]) AS
SumOfSumOfDistance
SELECT [Activity Summary By Week].[Activity]
FROM [Activity Summary By Week]
WHERE ((([Activity Summary By Week].[Athlete])=[Forms]![MasterGraph]!
[Getathlete]))
GROUP BY [Activity Summary By Week].[Activity], [Activity Summary By
Week].[Athlete], [Activity Summary By Week].[Athleteid]
ORDER BY [Activity Summary By Week].[Activity], [Activity Summary By
Week].[Athleteid]
PIVOT [Activity Summary By Week].[weekrange];