F
Flopbot
Hi,
I know this will probably be obvious. I changed the names of all my forms,
subforms, and queries to something a little more standard. Up to that point,
one of my control boxes worked perfectly but has since stopped working and I
get the error message: #Name? Basically, the control is supposed to add
together two subtotals located on the form footer section of my subform. I
have triple checked the names and format of the following equation and
everything looks perfect to me. I’ve also checked links and every properties
box I can find. Is there something I’m missing or does Access ‘03 not like
my choice of names?
New Equation (doesn’t work):
=Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form!Subtotal))+Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form![Subtotal Other Hours]))
Old Equation (worked):
=Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form!Subtotal))+Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form![Subtotal Other Hours]))
I know this will probably be obvious. I changed the names of all my forms,
subforms, and queries to something a little more standard. Up to that point,
one of my control boxes worked perfectly but has since stopped working and I
get the error message: #Name? Basically, the control is supposed to add
together two subtotals located on the form footer section of my subform. I
have triple checked the names and format of the following equation and
everything looks perfect to me. I’ve also checked links and every properties
box I can find. Is there something I’m missing or does Access ‘03 not like
my choice of names?
New Equation (doesn’t work):
=Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form!Subtotal))+Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form![Subtotal Other Hours]))
Old Equation (worked):
=Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form!Subtotal))+Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form![Subtotal Other Hours]))