Problem: You have a symbolic edit box (table bound) that contains the sum of an edit table column. You regularly update the edit table column from elsewhere in the form by doing a Get_Property array, changing amounts in the array and placing the array back into the edit table with a Set_Property. Now somehow you need to force the symbolic edit box to re-calculate the sum of the modified edit table column.

I have read everything in this forum I could find and tried applying the calculate event to the edit box, but since the calculate event is really designed to apply to an edit table nothing happens. Currently the only way I can force the symbolic(calculated) field to update is if I manually go to the edit table and enter something in the column that is being totaled. There is also discussion of the @RECORD vs RECORD and resetting DEFPROP of the edit table but I could not figure out if they apply here and if so how.

Bill,

Use the DEFPROP property when you set values in the edit table, not the ARRAY property. With DEFPROP you can set either a single cell, a row, a column, or the whole content. Doing the changes with DEFPROP (or INVALUE) is necessary to get CALCULATE to work.

Then send a CALCULATE to the edit box:

Stat=Send_Event( EditBoxCtrlName, "CALCULATE" )

CALCULATE is not just for edit tables. I get it to work with an edit line at least. Btw - why do you need a whole box for just a sum? (Oh, I see. You want it right justified.)

I'm fairly confident you'll get it to work.

- Oystein -

Thanks that worked great… I feel guilty alway asking for help and not beening able to provide any to other users, maybe someday…

I really appreciate your help…

Bill,

You're welcome. I've got so much help from this list myself it's only fair I contribute.

- Oystein -

View this thread on the forum...