subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form with 4 tap pages, Information, Members,notes & Gifts & Tithes.
On the Gifts & Tithes tap pages I created a subform that allows you to enter
a currency in three fields, Gifts, Tithes and Others. I am trying to display
the totals of these three fields on the same tap page (Gifts & Tithes). My
formula is =[Gifts]+[Tithings]+[Others]. I placed this formula in the Form
Footer and created a text box on the main tap page with the formula
=[Household subform]![Total].

'Total' is the name of the text box in the form footer. when I go to form
view the text box displays #error. WHAT AM I DOING
WRONG!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
try

=[Household subform].Form![Total]

btw, if Gifts, Tithings and Others represent separate fields in a table,
your design is not normalized. you may not want to redesign this database,
but i urge you to read up on table normalization before beginning your next
project.

hth
 
Back
Top