northwind database... slight change in my program

[poo via AccessMonster.com]

having seen the example of the northwind database...
i am trying to build the same program.but with little change .

the order entry form has a sub form order details .
now when i select the name of the company from the order form i want it to filter the respective nsme of products in the subform for that particular customer ...
currently in the example it filters all the products in the subform
i knw i have to use filter ... but then nothing seems to work. need help everything is same in my program the feilds and relations soo any help will be appreciated .
thanx

 

[Penguin]

Are you trying to see all orders for a certain customers? If so you
need to base the subform on the CustomerID not the OrderID. Then use a
query show all orders for customers. I suggest creating a new form and
not using the sample form.