Datasheet Form Total Calculation

N

Nan Hauser

I have a datasheet form that has a subform that is also a datasheet. The
form has a field "Placed" that is the total of the "Placed" field in the
subform. When I first open the form, the value of "Placed" is #Error. When
I click on the + sign of each record in the form to show each subform, the
value of "Placed" is changed to the correct amount. How do I get the correct
amount to display when I open the form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top