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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Form on Combo Variable 2
Combo search and form filtering 0
Total filtered record count on filtered adp form 1
Using DSUM to get running total on a filtered form 0
filtering a form based on a filter on an open form 1
Error Message "Cannot apply filter on one or more fields specified 0
Access 2007 Open forms with FilterOn and form fails to open 5
Error on filtering data in a from 0

Top