Is it possible to create a running sum in a form.
I have a module which needs to display bank account information if the expected total does not match a bank statement. I then need to look through the various entries to find the error (small number of entries, so easy task).
I started using a report which I opened in Preview mode. But as I need to take different actions depending on what I find, I need a msg box after I’m finished. If I place this in the module, then I cannot halt execution of the module till I have found an error. The msgbox therefore opens, and takes the focus, and I can’t use the form.
I next tried a form which I can open in Modal property set to yes. This lets me check my statement for as long as I want, but I can’t find an obvious way to create a running sum. Obviously, I don’t want to store the balance, as it should be a calculated field, but I can’t see a way to do it.
All I want is a count on a currency field called [PayDepAmount]. Alternatively is there a way to give the report preview the focus while I investigate?
Can anyone help?
Thanks
Colin McDonald
colinmac@blueyonder.co.uk
