MS Access 2000, SQL query, Calendar control

[Hautis]

Hi!

I have a SQL-query:

SELECT SUM(Table.Column) AS Total
FROM Table WHERE Table.Date = [Forms]![MyForm]!
[ActiveXCtl].[Value]

I have a calendar control and that query in an edit-
control on a form. Calendar control's Click-method:
Private Sub ActiveXCtl_Click()
Form_MyForm.Total.Requery
End Sub

My problem is this:
When I click on a date on the form the result of the
query should be updated, but nothing happens. What is the
problem here?