Error in total on form

[sbooth]

Okay, I know this is probably simple, but I am getting an error in putting a total on a form. I have the following:

Subform name is EntryDetail Subform
I have a field in the footer called TotalEntry that calculates the total entry. The formula is =sum([EntryAmt])

Form name is Entry
I have a textbox with the control =[Entry Subform].Form!TotalEntry

The text box shows #Name?

I am attaching a copy of the database.

Any ideas?

 

[boblarson]

Change the formula in the Text box on the main form from

=[Entry Subform].Form!TotalEntry

to

=[EntryDetail Subform].Form!TotalEntry

 

[boblarson]

Oh, and I would HIGHLY suggest you get rid of the lookups defined at table level. Use them at form level but avoid them at table level.

See here for more about that:
http://www.mvps.org/access/lookupfields.htm

 

[sbooth]

Thanks. That worked. I looked at this probably a hundred times and didn't see that.