developingprogrammer
asked on
using vba to sum subform values
hey guys,
i know that if i want to sum the subform's records for a particular field i can put a textbox in the header or footer with the control source of "=sum([fieldname])"
however, how can i do it with VBA?
i want to sum it based on the subform's recordset not a dsum using the same criteria. essentially what the user sees should be what is being summed. (excluding filters - they're disabled = )) )
thanks in advance guys!!!! = ))
i know that if i want to sum the subform's records for a particular field i can put a textbox in the header or footer with the control source of "=sum([fieldname])"
however, how can i do it with VBA?
i want to sum it based on the subform's recordset not a dsum using the same criteria. essentially what the user sees should be what is being summed. (excluding filters - they're disabled = )) )
thanks in advance guys!!!! = ))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok cool thanks gustav!! Thanks boag2000 as well!! = ))
You are welcome!
/gustav
/gustav
ASKER
= ))
Thanks, but I really was not seeking any points, I was just curious...
You can give all the points to cactus_data
JeffCoachman
You can give all the points to cactus_data
JeffCoachman
Not a problem for me, Jeff.
/gustav
/gustav
ASKER
well Jeff your question have always helped me question myself in a very constructive way too so if gustav doesn't mind i would like to show my appreciation for you taking a look at my question and helping me out! = ))
Sometimes asking questions actually helps me learn too...
Sometimes a person will have an interesting reason for asking a question...
;-)
Jeff
Sometimes a person will have an interesting reason for asking a question...
;-)
Jeff
ASKER
Haha yup yup I've noticed and I've learnt so much from all the questions people've asked on my behalf prior to me even thinking of it!! Haha = )) thanks Jeff!! = ))
ASKER