Sum on filtered form gives #error

A

Atlas

Access 2003, adp + ADO + MS SQL Server, Continuos form.
On the footer there's a field that has =Sum([myFld]) control source.

With no filters it works perfectly.

When some filters are active it shows "#Error".

Here's the code I use to filter the form:

Me.Form.Filter = filterString ' some string here

If Me.Form.FilterOn = False Then
Me.Form.FilterOn = True ' activate the filter
End If


What's wrong?

Thanks
 
Top