Hiding Parameter Dialog Boxes

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];
 
S

scubadiver

I assume when you created a copy of the graph the referencing for the
criteria was changed as well (apologies if it is an obvious question)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top