Multiple Items Form Issues

[MsDYJ]

I'm building a project management DB in AC07. I have created a multiple items
form that I'm using as a dashboard to show all of my incompleted projects.
For each record it just displays a project ID, priority, status,...and actual
cost of the project. Everything is being pulled from a query except the
actual cost, which is an unbound textbox

The actual cost equals the total material cost plus total resource cost. Now
in the main project form there is also a unbound text box that calculates
actual cost. The code for it is

=NZ([Forms]![frmProject]![sbfResources]![ResourceSum])+NZ([Forms]![frmProject]![sbfMaterials]![MaterialsSum])

However, this same code does not produce the same results in my dashboard.
The only way I can get the actual cost to display any amounts in the
dashboard is if the project form is open at the same time, and even then it
displays the same cost for both projects(depending on which project is open
in the project form) So what happens is that is project 1 is $100 then all
projects show $100, but if project 2 is open and it is $200, then all my
projects equal $200 on the dashboard.

If I open the dashboard with out the project form, I get #Name?

I've tried different ways but cannot seem to correct this. I'd greatly
appreciate a push in the right direction.


Thanks,
MsDYJ

 

[Mark Andrews]

You need to do the dashboard off a query that calculates actual cost.
So similar logic in the query except use
ActualCost: Nz([tblProjectLine].[ResourceSum]) +
Nz([tblProjectLine].[MaterialsSum])
for example.

I'm not entirely sure if your projects are made from two tables (tblProject
and tblProjectLine) or just one table (tblProject), but using a query to
perform the calc is the answer in both senerios.

Hope that made sense
Mark
RPT Software
http://www.rptsoftware.com

 

[Klatuu]

The controls on a form that is not open do not contain any value. You need
to construct a query or expression that will return the value without the use
of the other form. Then in the Current event of the form when you change
projects, you need to requery the control.