By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Displaying both the master and its details as a grid

P: n/a
Hi,

My (main)form has a subform that contains the details of the mainform. The
default view of the mainform is 'single form', the default view of the
subform containing the details is 'Datasheet' - Datasheet displays the data
of the associated table as a grid.

I want both the mainform (the master) and the subform to be displayed as
grid. But after changing the default view of the mainform to 'datasheet',
the subform disappears completely - probably because it is "part of" the
mainform?
Isn't there a way to display both the mainform and the subform as a grid? I
would suprised if this is impossible!

Any idea's?

Thanks in advance!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Shiva wrote:
Hi,

My (main)form has a subform that contains the details of the mainform. The
default view of the mainform is 'single form', the default view of the
subform containing the details is 'Datasheet' - Datasheet displays the data
of the associated table as a grid.

I want both the mainform (the master) and the subform to be displayed as
grid. But after changing the default view of the mainform to 'datasheet',
the subform disappears completely - probably because it is "part of" the
mainform?
Isn't there a way to display both the mainform and the subform as a grid? I
would suprised if this is impossible!


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

In Access 2000, & higher versions, you can insert subdatasheets into
datasheets - just like form/subform.

I've noticed that sometimes the subdatasheet doesn't show. I open the
forms in design view, change some things to Dirty the form & save it.
If that doesn't work, I delete the subform control on the main form;
save main form; open the main form & drag the subform onto it. That
usually causes the subdatasheet to appear.

Remember that the subdatasheet is visible until you click the + sign on
the main datasheet's record.

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

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

iQA/AwUBQgWH0oechKqOuFEgEQLixQCg1VmwM9mxoPBLts7Te1T216 zhel8AoOYQ
9o/lrGvzxEcrS2aESVSTRiNE
=TgNh
-----END PGP SIGNATURE-----
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.