Cascading Combos (1 Viewer)

[AdelaideKiwi]

I know I'm close but just need some help with the attached please.

The Product Type is the parent and the Product Sub Type is the Child.

Just want to show the filtered fields in the child when the parent is selected in the form.

Thanks AdelaideKiwi

 

[MajP]

1. Bind the Product combo to 1 not 2
2. Requery subtype combo in its on enter event
3.

SELECT
tblProductSubType.ProductSubTypeID,
tblProductSubType.ProductSubType
FROM tblProductSubType
WHERE
(((tblProductSubType.[Product Type])=[forms]![frmProduct]![Combo16]))
ORDER BY
tblProductSubType.ProductSubType;

 

[arnelgp]

on Combo16, i change the Bound Column to 1 (ProductTypeID).
see the AfterUpdate event of this combo.

 

[AdelaideKiwi]

Wow! Thanks MajP .... Savant indeed

 

[AdelaideKiwi]

on Combo16, i change the Bound Column to 1 (ProductTypeID).
see the AfterUpdate event of this combo.

Thanks arnelgp - I did both of these - thank you

 

[AdelaideKiwi]

The db above was a training db and based on your advise I got it working but when I went to do it in my actual db - it seems to have a problem with requery?

 

[arnelgp]

check this.

 

[AdelaideKiwi]

Brilliant - thank you again arnelgp

 

[arnelgp]

goodluck