Displaying both the master and its details as a grid

[Shiva]

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!

 

[John Vinson]

Isn't there a way to display both the mainform and the subform as a grid? I
would suprised if this is impossible!

You can (if you insist!) set the main form's view to Datasheet and set
its Subdatasheet property to the name of the table you want to see as
a subdatasheet (if you have A2000 or later).

What would you like to see if you had 2473 records in the main table,
with an average of 9 related records each? 24730 lines on the screen?

An alternative is to have two side-by-side correlated subforms,
preferably in Continuous view (rather than the rather inflexible
datasheet view); search for "correlated subforms" on
www.mvps.org/access for an example of how to do so.

John W. Vinson[MVP]

 

[Shiva]

You can (if you insist!) set the main form's view to Datasheet and set

its Subdatasheet property to the name of the table you want to see as
a subdatasheet (if you have A2000 or later).

What would you like to see if you had 2473 records in the main table,
with an average of 9 related records each? 24730 lines on the screen?

An alternative is to have two side-by-side correlated subforms,
preferably in Continuous view (rather than the rather inflexible
datasheet view); search for "correlated subforms" on
www.mvps.org/access for an example of how to do so.

Thanks for your answer, I'll check it out!