Hello Everyone!

I have an Access adp with a form that filters a subform. My problem is that when the form changes after the filter applies the summary of a field still displays the original total rather than the total for the filtered values.

Right now the summary field's control source = "=sum([field name])".

As far as how I am filtering the subform, it is standard VBA;

me.subformname.form.filter = "filter"
me.subformname.form.filteron = true

Any help is greatly appreciated.


Thanks,
Jesse

__________________
Thanks,
Jesse

Jesse-

You don't say which version of Access. Access 2000 ADPs are chock-full of bugs. You could try doing a Me.Refresh after applying the filter to see if that recalcs the the Sum in the subform. Or, you could get down and dirty and do Me.subformname.Requery to force it to refetch the data.

By the way, is your subform based on a View, Function, or Stored Procedure? If it's a View, then applying a filter by setting the Filter and FilterOn properties (Access 2002 or 2003) should send the filter to the server for execution (Access sets and sends the SeverFilter property). In Access 2000, you must explicitly set the ServerFilter property. If the form is based on a Function or SP, Access must still fetch the output of the SP or Function to the local machine and then apply the filter - not very efficient. You'd be better off using parameters and setting the Input Parameters property.

John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"

Sorry for not statting the version (It's 2003), and more importantly thank you for replying.

As far as what it was bassed on, well I had tried every form from typing the actual select querry against the table to views and stored procedures (without parameters). That last one is the important one since that is actually how I got it to work after reading your reply.

I do not know if it was lazyness or grom going nuts staring at my screen all day.....
Anyway I deleted everything and started from scratch again this time taking notice of a section in the subform properties called "INPUT PARAMETERS", Duhhh on me!! So I wrote an sp with the two key parameters required to apropriately filter the list and set the "input parameters" value to look at the values in the fields in the main form and "CHACHING" it worked!

Thanks again for taking the time, I really do apreciate it.
Jesse

Thanks,
Jesse