PDA

View Full Version : Disappearing values in combo



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

Meltdown
09-02-2004, 08:14 AM
OK, thanks to anyone who looked at it, I have a solution for this, I switched the sub-form from a continuous form into a datasheet and it works now.