Subdatasheets - How to use in subform?

I've figured out how to insert subdatasheets into tables and queries - just
open the table/query, select subdatasheet from the Insert menu, and play
around with the Link Child/Link Master fields until you get what you're
looking for. Easy enough.

But how do I use these in my forms? I tried dragging a table with a
subdatasheet directly onto a form in design view, but when I opened the
form, no little crosses. I don't want to give my users direct access to the
tables. How do I get subdatasheets into a subform? Is there a way to open
a table/query with a subdatasheet inside a form? Other alternatives?

Thanks in advance.

re: Subdatasheets - How to use in subform?

To get a subdatasheet into a form, you need to create a subform in Datasheet
view. Create a second form to use as the subform, set it to datasheet view,
and drag/drop it into the main form. Set the Child/Master links as
appropriate.

--
Wayne Morgan
MS Access MVP


"deko" <www.clearpointsystems.com@use_contact_form.com> wrote in message
news:u9KDd.9206$5R.9138@newssvr21.news.prodigy.com ...[color=blue]
> I've figured out how to insert subdatasheets into tables and queries -
> just
> open the table/query, select subdatasheet from the Insert menu, and play
> around with the Link Child/Link Master fields until you get what you're
> looking for. Easy enough.
>
> But how do I use these in my forms? I tried dragging a table with a
> subdatasheet directly onto a form in design view, but when I opened the
> form, no little crosses. I don't want to give my users direct access to
> the
> tables. How do I get subdatasheets into a subform? Is there a way to
> open
> a table/query with a subdatasheet inside a form? Other alternatives?
>
> Thanks in advance.
>
>[/color]

re: Subdatasheets - How to use in subform?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Both the form & the subform have to be datasheets. The way I do it is
create the 2 forms making sure the only view possible is Datasheet; then
open the main form in design view & drag the subdatasheet form onto the
main form.

In Acc2000 and Acc2002 I've found that sometimes the "little cross"
doesn't show up when the form opens! I've done things to the forms
(which I don't remember what) and the cross appears. Hmm... Not sure
what causes that. Maybe someone else knows.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQeAqF4echKqOuFEgEQIORQCeNq9EdQmS1WAqkMAScsN8RF 5VVeoAniIV
7hyg2bxs8mwM60qh1GXE87E4
=vVn9
-----END PGP SIGNATURE-----


deko wrote:[color=blue]
> I've figured out how to insert subdatasheets into tables and queries - just
> open the table/query, select subdatasheet from the Insert menu, and play
> around with the Link Child/Link Master fields until you get what you're
> looking for. Easy enough.
>
> But how do I use these in my forms? I tried dragging a table with a
> subdatasheet directly onto a form in design view, but when I opened the
> form, no little crosses. I don't want to give my users direct access to the
> tables. How do I get subdatasheets into a subform? Is there a way to open
> a table/query with a subdatasheet inside a form? Other alternatives?[/color]