This seems to almost work, however, there is something wrong that I can't pinpoint. I put this code in the Next Button Click Property and I can do it one time properly then it will not got any further.

Thanks for the help.

nick

>>On a one to many form:
>>How would I create a field do display the total of all child records for the parent record that you are currently on?
>>
>>Nick
>
>Here's one way...
>
>put this code in your navigation control method after the parent pointer has been moved
>

>SELE Child
>SUM 1, nField1, nField2 TO lnCount, lnField1, lnField2 ;
>  FOR Parent.key = Child.Key
>SELE Parent
>THISFORM.Refresh()
>

>
>lnCount gives a count for the number of children
>lnField1 is the numeris total for field nField1
>lnField2 is the numeris total for field nField2
>
>HTH