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 TruaxOP
@Reply 4 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.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 3.
