#NAME? error on total for subform in main form (1 Viewer)

RoyinForest

Registered User.
Local time
Today, 00:28
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

  • Help needed.zip
    718.7 KB · Views: 73

boerbende

Ben
Local time
Today, 09:28
Joined
Feb 10, 2013
Messages
339
Are you sure your subform in review is also called subform_parts_used?
 

RoyinForest

Registered User.
Local time
Today, 00:28
Joined
Aug 2, 2007
Messages
31
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!!
 

RoyinForest

Registered User.
Local time
Today, 00:28
Joined
Aug 2, 2007
Messages
31
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

Top Bottom