Running sums on forms

[YSKhatib]

Hi,
Does anyone know how to make a textbox hold a running sum value on a form? It's pretty straight-forward in reports, but it don't work on forms. I need the records to have serial numbers.

 

[mderby]

need more info

Sorry guy, i don't guite catch what you are trying to achieve.

you want to sum up a running number based on the record fetch is it ? and then display it in a text box in the form.

mderby.

 

[YSKhatib]

What I want to achieve is making an unbound textbox have a sum running on it. This helps in making serial numbers for rows, or for calculating accumulative sums.

In reports, you just create a textbox with control source =+1 and there you have it. That will give you the serial number you want. In forms it don't work. A friend told me about a DSum() function, but I didn't get him.