Access 2007

I have a subform that the user can toggle between datasheet and form view.
In form view it shows quite a nice task costing input form with lots of
shading, flow arrows, etc so the user can see a comprehensive view of how
the cost of a task is calculated from a few basic input variables.
In datasheet view it presents a much simpler subset of the fields to allow a
user to bang in a task code and its variables very quickly.

This has been working very nicely but now, in the form view, in the subform,
we need to insert another subform because we now need an unlimited number of
equipment records against a single task line.

This works and looks fine in the detailed (form) view but as soon as we
switch to datasheet view we now have the plus (+) signs appearing.

I don't want them.

I have played around with the form properties to prevent the sub datasheet
dropping down by default.
I have played around with code that modifies the visibility and columnhidden
properties of the sub sub form.
I have even tried some code that removed the object source of the sub sub
form as the user switches to datasheet view - this allows the datasheet to
not display the plus signs on the first time in (we come in in datasheet
view first of all) but once we switch to detail view and then back to
datasheet view, even though the code removes the sub sub form object source,
we suddenly have plus signs again.
Now, if we click on them the program crashes.

Any suggestions ?
Many thanks in advance
Tony Epton

On Mar 4, 2:58*am, "aceware" <acew... (AT) iinet (DOT) net.au> wrote:
Did you consider the possibility of having two separate subforms,
where a selection on the first subform causes the second subform
(possibly with a datasheet view) to show records related to that
selection? It seems best to avoid going to a subform within a subform
if possible. I have done something similar with datasheet views in
separate subforms and was quite pleased with how it functioned.

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com

Did you consider the possibility of having two separate subforms,
where a selection on the first subform causes the second subform
(possibly with a datasheet view) to show records related to that
selection? It seems best to avoid going to a subform within a subform
if possible. I have done something similar with datasheet views in
separate subforms and was quite pleased with how it functioned.

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com

Good thinking James
I often use that arrangement for 3 or 4 level hierarchies.
However, usually each level in the hierarchy has about the same amount of
information in it.
In this case the parent subform has about 60 pieces of information and the
child would have about 4 pieces of information and I'm trying to tuck it
inside the parent form at a particular location (ie where the fixed length
list used to be - ie replacing naughty lack of normalisation with the right
thing).

However - it is a good idea - if I can make it look ok cosmetically then I
might go that way.

Many thanks
Tony