Subdatasheet in Forms

  • Thread starter Thread starter Manuel
  • Start date Start date
M

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
 
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.
Click to expand...

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.
 
Back
Top