Probelms with datasheet viewing

[jimoharry]

Hey

I made a form which displays formulas such as [unitprice]*[quantity]. These forumulas are working perfectly when I display the form in 'form view'. However, when I open the form in 'datasheet view' it displays '#error' in the same field. I think the problem has something to do with me attaching a subform to the form. As when ever I click on the '+' to display the subform in datasheet mode, the '#error' becomes into a correct value.

Why is this so?

I would appreciate the help.

Thanks

 

[ansentry]

In my opinion [unitprice]*[quantity] should be done in the query that is the source for the datasheet.