Form Totals - Microsoft Access Expert 3


	Back to Access Expert 3 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Form Totals

Sandra Truax

3 years ago

I created a continous form for my checkbook database, and created a field in the form's footer to sum the deposits and Payments, and it works perfect.

If I use the form as a subform by dragging and adding it to the main form, it still works right.

HOWEVER, I want to use it so that the Subform named Register displays the form when a label is clicked by using the code Register.SourceObject = "TransactionsF", for some reason the totals in the footer always says #Error. Everything else is right.

I change the Register.SourceObject with three other forms, and they all work right, but then again, they don't have totals in the footer.

How can I fix this?

Sandra Truax OP @Reply

3 years ago

11 hours later, I finally fixed this myself. I deleted the =Sum(Payment) from the unbound box, and put this is the code in the forms On Current Event.  I'm sure this isn't the "right way", but it works.

    PaymentSum = DSum("Payment", "Transactionq", "AccountID=" & Forms!startupf!AccountCombo & " AND Month(TransactionDate)=""" & Forms!startupf!DateFilter & """")

    DepositSum = DSum("Deposit", "Transactionq", "AccountID=" & Forms!startupf!AccountCombo & " AND Month(TransactionDate)=""" & Forms!startupf!DateFilter & """")

	Adam Schwanz @Reply 3 years ago
If it works, it works :P, looks fine to me.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 3.

Next Unseen