Subdatasheet in Forms

[Manuel]

Hi:

I have a query which has a subdatasheet defined. When I run the query I see
the "plus" (+) sign and am able to drill down to see the child records.

However, when I tie the same query to a form, and set Default View for the
form to "Datasheet", the "plus" sign disappears, and I'm unable to drill down
to the child records (only the Parent record displays).

Can subdatasheets not be used with forms?? I thought they could.

I'd appreciate any assistance you all can provide.

Thanks,
Manuel

 

[John W. Vinson]

Hi:

I have a query which has a subdatasheet defined. When I run the query I see
the "plus" (+) sign and am able to drill down to see the child records.

However, when I tie the same query to a form, and set Default View for the
form to "Datasheet", the "plus" sign disappears, and I'm unable to drill down
to the child records (only the Parent record displays).

Can subdatasheets not be used with forms?? I thought they could.

Only with Datasheet forms. Check the form's Default View property.

You can (and probably should!!!) use a (single) Form with a (continuous)
Subform rather than any sort od datasheet.