Cascading Combo Boxes have a Frustrating Problem

[Scalec]

Hello!

I'm creating a Costume Database for my school's theatre department. In the form to enter a new costume, there is both a "Clothing Category" (Tops, Bottoms, Headwear, Footwear, etc.) and a "Clothing Subcategory" (For Headwear; Hats, Helmets, Wigs, etc.) combo box. I have successfully built a query of Subcategories so that the Subcategory box shows the appropriate subcategories once a Category is chosen in the form.



However, once I go to click on one of these subcategories and then leave it, I am given an error message that says that "The Value you entered isn't valid for this field." It does, however, accept numerical values. Which doesn't make any sense to me because there is no numerical value attached to the subcategories (at least not anymore. There was a primary key field that corresponded to the correct subcategories, but in an effort to fix this problem I edited by subcategories so that they themselves could be the PK. No dice).

Could anyone please offer me some advice on how to fix this?

[Micron]

Likely as part of your edit you did not change the bound column of your combo box. It is also possible that the column count is now incorrect as well. Check those property sheet values for those controls.

[Scalec]

Likely as part of your edit you did not change the bound column of your combo box. It is also possible that the column count is now incorrect as well. Check those property sheet values for those controls.

OK. What should the bound column and column count be, then?

[Scalec]

I managed to figure out the bound column and column count issue, and it's displaying perfectly! But now the records in the table won't display the Subcategory choices - it's all blank. Please, does anyone have any advice on how to fix that?

[orange]

There are several tutorials on comboboxes here.

We really need to see what you have.
Good luck.