Nick, check if you have the parent child selected when you are using the navigation buttons. You might wish to put SELECT ParentTable in the WHEN method of the buttons, so your form is ALWAYS in the correct area.
HTH
Barbara
>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