Sum a field in subform (1 Viewer)

p4nny

New member
Local time
Today, 09:49
Joined
Mar 16, 2020
Messages
15
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

I’m here to help
Staff member
Local time
Today, 02:49
Joined
Oct 29, 2018
Messages
21,357
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])
 

Users who are viewing this thread

Top Bottom