Access Continues Forms

[Pleasure]

Hello from Greece.
I have a little problem. Let's say I have a Tubular (Continues) Form with these Textboxes (assigned to fields in a Table Customers) :

SerialNo Name Date_Of_Birth Value
1 Theodore 9/12/76 5
2 Theodore 9/5/70 6
3 John 4/4/90 3
4 Maria 7/4/90 2
5 Anna 12/5/05 3

Then I apply filters (By right clicking and filter by selection). Let's say multiple filters for Name and Date_Of_Birth.

Is there any possible way, after the filtering, to have the Sum of the Value of each record (filtered Continues form) in a seperate textbox?

Thank a lot ...

 

[Pleasure]

Well I tried that. Actualy I created a Textbox and applyed as Value this

=Sum([The Number Field])

But nothing happend. I' m sure the syntax is ok. I don't know, maybe you can help out with this.
Then I figured something else: To move to the first record of the form, focus on the textbox I want to sum and take the value to a variable. Then move to the next record (with a for - next loop) and do the same etc until i reach the last record.

This works but is very slow. If I have too many record in my Form this method is not the appropriate.

Any help - Comments - suggestions ??

 

[boblarson]

Also make sure that the text box that you are using is not named the same as a field in your form. The text box should be named something like "txtMyValue" if you have a field in the recordsource of the form that has the name "MyValue." (those names just made up as an example).

 

[Pleasure]

I did not set the Forms Footer. Now it's working nice. Thanks a lot my friends. You helped me a lot.