I have a grid I am using for some simple data entry. What I would like is a dummy column that can hold a calculation of two other columns/fields (unit_price and quantity). The value displayed needs to be dynamic, so if a user changes a unit_price or quantity, the column with the total value will display the changed amount. I have used a calculated field in the view, but the update was not displayed until I updated the view (committed the change), which is not what I want ot do. I want the user to see the new amount calculated, and then choose to save, or cancel, or make another change to another record, etc. I have tried to set the recordsource of the grid column to an array that I dynamically change, but the only value displayed is the value of the first element in the array. I hope someone else has tried this with more success.
Thanks for any help.
Mike D
Devman
mdevlin /AT/ ajdebruin .DOT com
©2001 Mike Devlin |
