Working with forms and sub forms

[hattrix86]

I'm having difficulty with this following problem:

I have a form consisting of a Main form, and several sub forms. There is a box in the main form which needs to display a number. This number is a sum of numbers from the various records in the sub form. However, it is more complicated because the sum is only made up of numbers that fit a certain criteria.

So essentially i have to take info from a sub form, weed out the ones that don't fit the criteria, and then add up the numbers left, and display it on the main form.

Helpppp please.

 

[NumbersMax]

I would try writing a query based on the same object (whether table or query) as the subform. Enter the criteria directly to the query or have the criteria come from a field in the form so that you can change it as the need arises. Use the Sum feature from the totals row of the query grid to sum the filtered contents.

Make the newly created query (specifically the summed data field) the control source for the form field that is to display the summed data.

Max