Hi all,

I am trying to filter a datagrid based upon stepping through records and suming the contents. What i am trying to do is get to select records that equal (or if the sum of records exceed the entry they revert to the previous record) or less than the entries specified in a combobox on a form.

I think i need a loop next statement for this but if anyone can give me some pointers be much appreciated, as i am really struggling with this.

Kev