Filtering subform thru main form

[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?

 

[Mike Painter]

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?

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

There are examples in help and the Northwind Database.