Sum a field in subform

[p4nny]

Hi,

I have a subform that is filtered using a separate combo box.

Each time, the subform is filtered, I'd like to sum a specific column/field.

Using vba, I've tried the On Current Event and Dsum but can't seem to get this working.

Any help is appreciated

thanks

 

[theDBguy]

Hi. No need to use VBA. You should be able to put an unbound textbox in the footer section of the subform with something like:

=Sum([FieldName])