Continuous subform within a continuous form - datasheet alternatives?

[toast]

Hello all,

I am looking for ideas for an alternative to datasheets to achieve a continuous subform within a continuous form.

I'm steering away from datasheets if at all possible because of their behaviour within a navigation control (persistent save prompts).

The basic set up is:
Each 24 hour period has a daysheet.
Each daysheet comprises of 3 or so shifts.
Each shift can have multiple deliveries.

The basic arrangement is:
Single form based on daysheet
Continuous subform to enter each shift
Continuous sub-subform to enter any deliveries each shift makes

At the moment, the only way I seem to be able to achieve this is have the shifts/deliveries in a subdatasheet.

Is there an alternative which will still keep the data entry simple and swift?

Any thoughts greatly appreciated.

 

[spikepl]

Nothing prevents you from putting two subforms (of whichever format) on a form, and then letting the second subform be related to the first. In this manner you can have a subsubform as continuous form, altough not co-located with its parent form.

What exactly is "(persistent save prompts)" ? Datasheets are pretty handy for subforms.

 

[toast]

Hi, thanks for the reply.

The problem is that every time a change is made to the datasheet (such as a column resize or a filter) it prompts you to save your changes when you navigate away. This only happens when using the navigation subform ('07 / '10).
While the problem seems reasonably well documented by searching the net, nobody seems to have come up with a solution yet.

I'll see what I can do with 2 linked subforms, rather than a subform and a sub-subform.

Thanks once again