cascading combo boxes and chart sub forms

S

Shannon

I am trying to create a recipe database by editing the microsoft template.

Ingredients are on a subform, and set up as a chart. I added a
subingredients combo box to the chart, so (e.g. for flour, all purpose, whole
wheat, etc.)
The chart is used because there are many ingredients in each recipe. My
problem is that when I select one sub ingredient, I cannot select any other
in the other rows. Depending on which coding I have in (I am new at this, I
just copy the code Microsoft offers and chnage the particulars), it sometimes
goes so that when I go to another row with another ingredient, the other
subingredients disappear, or, I can only change one sub ingerdient each time
I open it, and then the other boxes kind of freeze up, and it asks me to save
before I exit.
By the way, I'm using bound combo boxes for this.
I assume I need a different piece of coding, but I'm a novice and don't
really know what to do.
 
Top