Parameter value

[Savanah]

I have a dialog box with options and a list box that I can choose the name of
the protocol, than I am running a line chart in a form, with a query on the
row source
SELECT [qry Projected Enrollment].[Max Of Week], Sum([qry Projected
Enrollment].[Sign Cons]) AS [Signed Consent], Sum([qry Projected
Enrollment].[In Screen]) AS [In Screening], Sum([qry Projected
Enrollment].Rand) AS Randomized, [qry Projected Enrollment].Projected FROM
[qry Projected Enrollment] GROUP BY [qry Projected Enrollment].[Max Of Week],
[qry Projected Enrollment].Projected, [qry Projected Enrollment].[Protocol
Name] HAVING ((([qry Projected Enrollment].[Protocol
Name])=[Me].[SelectCategory].[Value]));
the problem is when come the graph it pops up a Me.SelectCategory.Value,
then when I entered the protocol name runs fine. How can I avoid the pop up,
even I choose already the name on the list box, how can I set the list box
choice be linked to the query.
Tia

 

[KARL DEWEY]

Try changing ---- HAVING ((([qry Projected Enrollment].[Protocol
Name])=[Me].[SelectCategory].[Value]));
to ---
HAVING ((([qry Projected Enrollment].[Protocol
Name])=[Forms].[YourForm].[YourListBox]));

 

[Savanah]

Thanks for yor response, but unfortunatelly did not work, it popped up
another parameter "qry Projected Enrollment.Protocol Name" and them when I
entered the protocol name it does not show the line chart. Tia

Try changing ---- HAVING ((([qry Projected Enrollment].[Protocol
Name])=[Me].[SelectCategory].[Value]));
to ---
HAVING ((([qry Projected Enrollment].[Protocol
Name])=[Forms].[YourForm].[YourListBox]));

I have a dialog box with options and a list box that I can choose the name of
the protocol, than I am running a line chart in a form, with a query on the
row source
SELECT [qry Projected Enrollment].[Max Of Week], Sum([qry Projected
Enrollment].[Sign Cons]) AS [Signed Consent], Sum([qry Projected
Enrollment].[In Screen]) AS [In Screening], Sum([qry Projected
Enrollment].Rand) AS Randomized, [qry Projected Enrollment].Projected FROM
[qry Projected Enrollment] GROUP BY [qry Projected Enrollment].[Max Of Week],
[qry Projected Enrollment].Projected, [qry Projected Enrollment].[Protocol
Name] HAVING ((([qry Projected Enrollment].[Protocol
Name])=[Me].[SelectCategory].[Value]));
the problem is when come the graph it pops up a Me.SelectCategory.Value,
then when I entered the protocol name runs fine. How can I avoid the pop up,
even I choose already the name on the list box, how can I set the list box
choice be linked to the query.
Tia