I've created a subform on my mainform by just dragging fields onto it in layout view so it looks like I have a datasheet in the middle of my form.
I opened the subform in Design View and added a textbox called txtTotalOwing to the Form Footer with the control source set to =Sum([txtAmountOwing]) where txtAmountOwing is the field in the subform that I want to total. In the subform's design view, this field appears as a single textbox.
I intend to display this Total on my mainform, but before referencing it, I check to see if it works. When I look at the subform in form view, the txtTotalOwing box says #Error.
I'm not sure what's wrong. I followed the procedure right off of a help forum, and I've discovered other forums with similar suggestions. I don't know where I went wrong.
I've never worked with subforms before, which is why I described what everything looks and how I made it I'm not even sure if I made the form correctly.