General information
Category:
Coding, syntax & commands
Hi Sandi,
>Does anyone know an easy way to create a running total (balance) in a grid. Since the user could change row one after entering row four, all rows must be recalc'd. What method should this code go in? Previously in Fox 2.6 I saved the record pointer, summed until reccount and then restored the record pointer.
I don't think you should use the grid to tally records, but rather the control source itsself. In the AfterRowColChange event fire a sum of your columns controls source and stick it in a caption or text box below your grid, or set it up so a text box automatically reads SUM(columnscontrolsource) and just do a ThisForm.Refresh() in the AfterRowColChange. Let me know if you need anymore help implementing this.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only