Cascading Combo

[YNWA]

Hi,

I have 2 combos on my subform sbfOrderDetails one called cboProductID and one called SupplierID.

These selections are stored in table OrderDetails.

I want to select a SupplierID and my combo cboProductID only show products that relate to that supplier.

My table Products stores the product name and also pulls in the Supplier name when you first enter a product.

Any ideas?

 

[mahenkj2]

In the row source of your product combo, you may build a query having criteria referencing to previous combo on the sub form (Supplier). So, row source should be filtered to your choice.

 

[Alansidman]

Here is a good thread on cascading combo boxes.

http://www.access-programmers.co.uk/forums/showthread.php?t=219997&highlight=cascading+combo+boxes

Alan