Displaying all records in a subform

[Jeff]

I am trying to figure out how to display all records in a
subform. For example, if you go into the orders form in
the sample database, how would I display all products in
the Orders Sub-Form?
Thank you.

 

[Guest]

You need to set the default view property of the subform
to datasheet or continuous form.

 

[John Vinson]

I am trying to figure out how to display all records in a
subform. For example, if you go into the orders form in
the sample database, how would I display all products in
the Orders Sub-Form?
Thank you.

Ummm...

You wouldn't WANT to, in that application, unless every customer were
ordering every product every time!

The Combo Box in the OrderDetails subform in Northwind already
displays all the products when you drop it down.

If you want a subform which displays all the records in its
recordsource, without reference to the value on the main form, just
set the Subform's Master Link Field and Child Link Fields to blank.
This should be done with caution, and you need to be sure you have
your relationships right!