How to fix error in Time and Billing Template

[Lilly]

There is an error in the 'Time and Billing' template that comes with Access which makes it useless. I am wondering if anyone knows the solution. In the form Clients>Preview Invoice>Print Invoice there is an error "#Name?" in the fields for 'Total Hours', 'Total Hourly Billing', and 'Total Expenses'. This is the information that is used to create the Invoice, so it makes the entire database non-functional. In design view of the form "Print Invoice" the formula for Total hours is " =IIf([Print Invoice Time Subform].Form.RecordsetClone.RecordCount=0,0,[Print Invoice Time Subform].Form![Total Hours]) ". I do not understand the coding enough to understand where the error might be. Please let me know how to fix this problem in the database.

 

[Jim Kennedy]

Is that just an observation, or do you need some specific
help?

-----Original Message-----
There is an error in the 'Time and Billing' template that

comes with Access which makes it useless. I am wondering
if anyone knows the solution. In the form Clients>Preview
Invoice>Print Invoice there is an error "#Name?" in the
fields for 'Total Hours', 'Total Hourly Billing',
and 'Total Expenses'. This is the information that is
used to create the Invoice, so it makes the entire
database non-functional. In design view of the
form "Print Invoice" the formula for Total hours is " =IIf
([Print Invoice Time
Subform].Form.RecordsetClone.RecordCount=0,0,[Print
Invoice Time Subform].Form![Total Hours]) ". I do not
understand the coding enough to understand where the error
might be. Please let me know how to fix this problem in
the database.