Filtering subform thru main form

  • Thread starter Thread starter Diane Imbody
  • Start date Start date
D

Diane Imbody

I have multiple vendors with muliple products. I have
created a Main form for ordering by vendor with a subform
of order detail. The order detail is from a query of
products with vendor ID. How do I make only the selected
vendor's products available for selection?
 
Diane said:
I have multiple vendors with muliple products. I have
created a Main form for ordering by vendor with a subform
of order detail. The order detail is from a query of
products with vendor ID. How do I make only the selected
vendor's products available for selection?
Click to expand...

Base the subform on a query that includes the vendorID as a filter.

There are examples in help and the Northwind Database.
 
Back
Top