Expand and Collapse Query/Form

[Guest]

I need help in making my Expand and Collapse Query/Form add data and display.

I was able to expand the query (which is done on a form - datasheet view).
I think MS call this subdatasheet on a form. When I expand, I enter employee
names and there are 12 columns for his level effort for the following 12
monts.

The main query/form is projects, following by 12 columns of manpower for the
12 months. For example, ACTS 12.5 12.5 12.5 ... The project is called
ACTS, and the 1st month requires 12.5 people, etc.

I want the ability to expand the project query/table to show all employees
(if any) for the ACT project. So, when I expand (+) sign on the Query/Form,
the subQuery/SubForm shows the employee column and its 12 months. I was able
to enter some names in the employee column and collapse the query/form and
expand again and I can see all of the names.

When I close the form and expand the project, I don't see anything. The
Query and Form are link via Project. I thought the table with employees
also have project and names. That should show all of the names. I an see
all of the entries if I change the forms Recordset Type to a snapshoot view
instead of a Dynaset I see all of the enteries. Snapshoot will now allow be
to edit which is how I was planning on additing more employees and changing
their work levels.

Can someone please help!!!

Thank You,

Gary

 

[[MVP] S.Clark]

FWIW, we recommend that you turn off the Subdatasheet for all tables. I
would also recommend that you not rely on its functionality to display data.
Instead, build a form with a subform.

Also, it sounds to me like you have a normalization problem. For example,
instead of having 12 coluimns, I would use only 2 for the level of effort.
MonthNo, ManPower