Meltdown
08-31-2004, 05:37 AM
Hi everyone, I have a problem with combo boxes and disappearing values.
I have 4 fields, Category(Combo), SubCategory(Combo), Brand and Client.
I'm assigning Brands to a client and the client may have products in different categories. When i select the second category eg Food, the subcategory displays a list of values. If the subcategory does not have the value the user wants they click a button to bring up a "Add Sub Cat" form, enter the new value,close the form, and the new value is in the combo...that all works OK.
The problem: If I select a second category,check the sub cat combo and find the value I want is not there, then click the "Add Sub Cat", clicking the "Add Sub Cat" button to bring up the form causes the values in the Sub category field to disappear!...they're still there actually because if you close the form and reopen, you can can see them.
Hopefully the sample database I've attached will make it clearer.(Access 2000)
Thanks for any help
I have 4 fields, Category(Combo), SubCategory(Combo), Brand and Client.
I'm assigning Brands to a client and the client may have products in different categories. When i select the second category eg Food, the subcategory displays a list of values. If the subcategory does not have the value the user wants they click a button to bring up a "Add Sub Cat" form, enter the new value,close the form, and the new value is in the combo...that all works OK.
The problem: If I select a second category,check the sub cat combo and find the value I want is not there, then click the "Add Sub Cat", clicking the "Add Sub Cat" button to bring up the form causes the values in the Sub category field to disappear!...they're still there actually because if you close the form and reopen, you can can see them.
Hopefully the sample database I've attached will make it clearer.(Access 2000)
Thanks for any help