Discussion Locked
Error# in Access control
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am creating a form(invoice) in Office Pro 2000. There are three subforms in this form. Each sub list services or products provided and their price. There is a subtotal control in each subform. There is a subtotal control in the form that refers to these subform subtotal controls.
The problem, when there is no record in one or more of the subforms I receive a error# in the forms subtotals controls but not in the subform controls. This error# also appears in the forms total controls.How can I get these controls to display a blank or a 0 when there is no records to subtotal.