Subform OK, Form error

[Rob007]

I have a subform whose source is a query that contains formulas e.g.
TotalCost: Products!CostPrice*(Products!OnOrder+Products!Unprocessed+Products!InStock+Products!Galvanised)

The subform is viewed as a datasheet and when I view it all the fields look fine however, when I view the subform in the form I have 2 out of the 4 fields with formulas in them displaying: "#Name?"

Has anyone ever experienced this before? Any ideas?

Thanks

 

[mdemarte]

Check your record source for those calculated fields. The #Name? error is basically telling you that it can't find at least one of those fields in order to do it's calculation. If your subform is based on a query, then your fields in your calculation should be based on the query, also.

 

[Rob007]

Thanks MDEMARTE,

The formulas do work, when I view the query in database view I can see the calculated values, they just dont work in the form - wierd. I have put the formulas in to the textboxes in the form and it is now working OK, just frustrating that it didnt do what it was supposed to.

Thanks for your reply.