Data in Subform

  • Thread starter Thread starter John Hannah
  • Start date Start date
J

John Hannah

I have a Main Purchase Order Form based on a Query showing
OrderID and SupplierID. Within this I have a Subform based
on another query showing Order and Product details. I want
users to see in the subform details of only the products
supplied by the supplier in the main form. Your help on
the best way to accomplish this would be much appreciated.
Thanks! John
 
I have a Main Purchase Order Form based on a Query showing
OrderID and SupplierID. Within this I have a Subform based
on another query showing Order and Product details. I want
users to see in the subform details of only the products
supplied by the supplier in the main form. Your help on
the best way to accomplish this would be much appreciated.
Thanks! John
Click to expand...

If the OrderDetails table includes a SupplierID field, try setting the
Master Link Field and Child Link Field properties of the subform to

OrderID;SupplierID

This will link on both fields, and you'll see only that portion of the
order which is from the selected supplier.
 
Back
Top