Recent content by ShuttleDIK

I have an error in a calculated field when the sub report doesn't generate. I've tried an IIF statement checking for IsNull, IsEmpty and IsMissing on the subreport field - to no avail. What's next? What am I missing? Thanks all!!

Thanks, Had it covered. The transactions are stored in a separate table. The Current Balance is always the Current Balance. I can always re-create any balance from any day. The only thing I was trying to do was update the current balance to reflect just that. If I placed that # in a field...

Ok - now you just arent' making sense to me. Why wouldn't I want to refer to balances in a database?! Not only a running balance, but the opening balance as well. Your short answers bring up more questions than they solve... lol Thanks,tho. :]

Why? I already have a column for the data I need - I just want the 'current balance' field to change. I did end up having to do a query tho. It worked out ok - just wasn't my first choice.... No big. Thanks for your help, tho. ;-]

Hi. I have a form which contains data from 2 tables. As info is entered into my Transactions table (through the form) - I want to adjust the balance field in my Accounts table by the transaction amount. My problem is: The equation and references I put in through the expression builder...