Displaying all records in a subform

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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

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