#Error in total of subform values when no records in subform

[cfwoodbury]

I am sure this must have been asked before. I have a simple main order form with a subform showing items ordered. I use a pop up form to actually populate the table on which the subform is based. When I open the mainfom, of course, there are no records in the table. So the TotalAmount field on the main form showes #Error. As soon as I add an item the total field works properly. It seems that if there are no records in the subform the main form total would be null. But, I have tried the NZ function and other means to test for null to no avail.

This is really only a cosmetic issue since things work fine once we start adding detail records. But, it would be nice to have the #Error not show up.

Thanks,

[always404]

What is the Control Source for the TotalAmount field?
How are you getting the total number of orders into that control?

You might be able to properly set the Total Amount field manually.
Or you might need to edit the expression you're using for you control source.

[cfwoodbury]

Thanks for your response. As often happens, with a little more trial and error I have come up with a solution. Because I do not want the user to be able to enter or modify records in the subform, I had set the AllowEdits, AllowDeletions and AllowAdditions properties on the subform to "no". So, upon opening the main form, the subform was completely empty. Changing AllowAdditions to "yes" causes a blank line to be entered in the subform when the main form is opened and then the #Error in the total fields is not present. Since all of the visible fields on the subform are locked, the user still cannot enter data directly to the subform. I use a pop up form to create table entries and as I enter items the totals all work fine.

Thanks again,