>>I'm working on a form that has several calculated values. Some are based on other values on the form, some are counts of records in related child tables, and some are sums of records in related child tables. I have no problem with the code required, I'm just wondering where is the best place to put the code because I've thought of so many? I'd really appreciate any input on your approaches and any reasons/benefits to why you did it this way. TIA
>
>I'd use a separate custom method for each of the recalcs; since it's a form, you can put custom methods into the form only (or formset, if there's one). Another (theory would say better) way is if you had a bizobj and add it all as its custom methods.
Thanks for the input. This was one of the possibilities I thought of but I decided to place the code in each calculated objects .Refresh event.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.