Form in chart view

[bjaj]

Hi

I have made a form in chart view based on query named
"Q_Fejl_3_month_back" and I can se the following in the property
"Record source" :
TRANSFORM Sum([Count Of T_FejlProIndivid]) AS [SumOfCunt Of
T_FejlProIndivid] SELECT [DatoOpr By Month] FROM
[Q_Fejl_3_month_back]GROUP BY [DatoOpr By Month] PIVOT [VareNr];

Now I want to specify witch "varenr" I want to display so I have added
this to the Record source proberty:
WHERE [Varenr] = "51606106"

so it look like this:

TRANSFORM Sum([Count Of T_FejlProIndivid]) AS [SumOfCunt Of
T_FejlProIndivid] SELECT [DatoOpr By Month] FROM
[Q_Fejl_3_month_back]WHERE [Varenr] = "51606106" GROUP BY [DatoOpr By
Month] PIVOT [VareNr];

Now I want to change the "51606106" to a variable.
I made a textbox on the form called "VareNr" and then change the
"51606106" to Me!VareNr but it don't work.

Can anyone help me whit that ?

best regards Ronald