Results 1 to 2 of 2
2007-04-27, 18:24 #1
- Join Date
- Jul 2005
- Earth, New Jersey, USA
- Thanked 0 Times in 0 Posts
Error Msg On Calculation (Access 2002)
On The Transaction Form I'm receiving a 2 Errors . Total Deposit & Balance txt boxes. I used a template to create the DB and I'm modifying it for my needs.
Total Deposits =forms!Transactions!<transactions Subform>.form![Total Deposits] . Balance =nz([Total Deposits])-nz([Total Withdrawals]) . I know Balance is bombing out because Total Deposits is bombing. Not sure what info you require, I attempted to upload the DB but I received an error msg. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
You're assistance is greatly appreciated. Thanks A Bunch!
2007-04-27, 18:46 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Error Msg On Calculation (Access 2002)
is incorrect. If this is on the Transactions form itself, the Control Source of the Total Deposit text box should simply be Total Deposit (without an = before it, and without explicitly referring to a form).
If you still have problems and want to attach a copy of your database, see <post#=401925>post 401925</post#> for instructions.