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