>>>I have a form using a one-to-many relationship and a grid. The grid displays data from two records, and the user can edit the data in one or both of these records. When they click on save, calculations are performed using this data.
>>>
>>>However, my formulas are only working on the first record. How do I tell it to use both records, one at a time?
>>
>>The grid has a refresh method, you should call, from the save.click.
>>
>>HTH
>
>Thanks Marc! I added ThisForm.grdTPD_Payments.Refresh to the beginning of my code in my save.click, but now my calculations only worked on the 2nd record! I guess I need to add some sort of loop now, any suggestions?
>
>Jeff
Jeff,
I have grid which perform calculations, but I perform calculation from Valid() or InteractiveChange() of the control in a grid cell when I change something in that record. I don't know if it suits your need in your case.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison