Hi,
Can anyone help me with this. Usually ok doing these but having a problem with this one.
using the Northwind DB and I have the Customer Order Form.
I have inserted a combo called cboSupplierID which lists Suppliers. I then have a combo called cboProductID which lists Product Names.
When I select my supplier, I want the product combo to filter to those items related to that supplier.
My products come from the Products table which has the fields for SupplierID and ProduceName in.
my supplier combo comes from a supplier table.
Any ideas? Thanks.
Can anyone help me with this. Usually ok doing these but having a problem with this one.
using the Northwind DB and I have the Customer Order Form.
I have inserted a combo called cboSupplierID which lists Suppliers. I then have a combo called cboProductID which lists Product Names.
When I select my supplier, I want the product combo to filter to those items related to that supplier.
My products come from the Products table which has the fields for SupplierID and ProduceName in.
my supplier combo comes from a supplier table.
Any ideas? Thanks.