#NAME? error on total for subform in main form

RoyinForest

Registered User.
Local time
Today, 04:19
Joined
Aug 2, 2007
Messages
31
I have an app that has two main data entry type panels. One (labelled DATA ENTRY) was created first and the other (labelled REVIEW) was cloned from it. There is a subform on each (same subform) that shows the parts used for an order and the TOTAL of them is shown on the main form below the subform.
The problem I have is that everything on the DATA ENTRY form works fine, but on the REVIEW form the TOTAL box just shows a NAME error (#NAME?).

I have screenshots of the form that works and the one that doesn't with their design and properties screens in a zip file
 

Attachments

Are you sure your subform in review is also called subform_parts_used?
 
THAT's IT! The name SHOULD have been SUBFORM_Parts_used but when I looked it was CHILD144. Once I fixed that, the total amount showed up. Not sure how I missed that (too close to the trees to see the forest I guess).

THANKS YOU SO MUCH FOR YOUR HELP!!
 
Glad I'm not the only one working on New Year's Day. Have a very happy new year.
 

Users who are viewing this thread

Back
Top Bottom