Hi,
I'm using Northwind.mdb as the basis for creating a simple supply order. I want to restrict the products that are available to order in the order subform based on a particular supplier in the main form. Ideally, I also want to restict based on the product category. "Mastering Access 2002" shows a Query by Form example that should work. I created a unbound combo box on the main form and it does work to restrict the products shown in the filter query. But when I put it together with the "apply filter" macro as a "After Update" event, it doesn't filter the products available on the subform.
Any ideas on what I'm doing wrong? Is the filtering technique the wrong way to go?
Thanks!
I'm using Northwind.mdb as the basis for creating a simple supply order. I want to restrict the products that are available to order in the order subform based on a particular supplier in the main form. Ideally, I also want to restict based on the product category. "Mastering Access 2002" shows a Query by Form example that should work. I created a unbound combo box on the main form and it does work to restrict the products shown in the filter query. But when I put it together with the "apply filter" macro as a "After Update" event, it doesn't filter the products available on the subform.
Any ideas on what I'm doing wrong? Is the filtering technique the wrong way to go?
Thanks!
