Filtering subform thru main form

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

Mike Painter

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.
 
Top