combo box on a subform (A2K)

[jalgier]

Greetings,

I have a combo box (ProductType) on a subform that when the user enters a value, it restricts the values on the next combo box (Products). The point being, when a user selects the ProductType (eg: Mirrors), only Products fitting that description will populate the combo box.

My problem is that when I go to the next record on the subform, when I change the ProductType combo box, it resets all previously entered Products (reflecting only ones that have the same ProductType). So if I enter ProductType 'Mirror' and select a Mirror under Products, when I go to the next record and select 'Shelving' under ProductTypes, only Shelving products appear not only for the current record, but all previous records. How do I set it so that each line item is independent from the next when the Products have been filtered?

Thanks in advance, James...

 

[David R]

Continuous subform? I had the same problem recently. Try this thread: http://www.access-programmers.co.uk/ubb/Forum4/HTML/006528.html