tacieslik
05-08-2001, 05:07 AM
Somebody please help!
I have 2 combo boxes (SupplierID and PartID). When I select a Supplier from SupplierID combo, I want the PartID combo to list all the relevent parts for that Supplier.
This kind of problem has come up a lot looking around the forum, and I've been semi-successful.
The problem is that the process works fine - THE FIRST TIME? This problem (I think) is to do with the Requery. For example, if I select a supplier and then select a part, it works. This will not work if I try it again. But if I go into Design mode and back into Run mode, it will work fine.
The second combo is in a subform and the first is in the main form.
I'm using the AfterUpdate option for the SupplierID combo.
Any ideas??
tacieslik@vivitech.co.uk
Many Thanks.
I have 2 combo boxes (SupplierID and PartID). When I select a Supplier from SupplierID combo, I want the PartID combo to list all the relevent parts for that Supplier.
This kind of problem has come up a lot looking around the forum, and I've been semi-successful.
The problem is that the process works fine - THE FIRST TIME? This problem (I think) is to do with the Requery. For example, if I select a supplier and then select a part, it works. This will not work if I try it again. But if I go into Design mode and back into Run mode, it will work fine.
The second combo is in a subform and the first is in the main form.
I'm using the AfterUpdate option for the SupplierID combo.
Any ideas??
tacieslik@vivitech.co.uk
Many Thanks.