Hello,
I have a form base on [Orders] table, in this form there are 2 combo boxes,named [FactoryID] and [Products]. [Products] combo box will be filtered by [FactoryID] combo box.
I've done it by a query in [Products] which takes value from [FactoryID], and a Products.Requery command in change event of [FactoryID]. So that if [FactoryID] changes, [Products] will do requery to update its list to match current [FactoryID].
But the problem is, this form has navigation buttons on bottom, which I can use it to navigate to other Orders, and in each order, FactoryID may be different, but seems Access does not consider this kind of changes on FactoryID as change event.
Therefore, if current Order is 1, FactoryID is A, Products will show A's product, but when I use navigation buttons to navigate to Order 2, and Order 2's FactoryID is B, Products still showing A's product unless I click and make changes on FactoryID combo box by myself.
Does anyone would give me some idea for how to solve this?
Thanks very much