Combo boxes

[leadoor]

I have a subform that include two combo boxes.
First combo box is a Color Category(Green,Blue,Red...)
The second is has the shades, it is limited by the category combo box
via a query and the afterupdate propery.
I open the form and select from category Blue and then select the
shade.
Move to the second row and select green,suddenly this changes the
shades available on the first row and the blue shade that i've allready
selected disapears.
How do i make the category combo box affect the shade combo box of it's
row only.
I hope that made sense.

 

[Larry Linson]

What you said would make perfect sense if all the records displayed on a
continuous forms view were separate entities, but they aren't. There is only
one detail section in the Form in continuous forms view (which apparently is
your situation); all the other lines you see are just copies of bound data
painted on the screen.

Unbound Controls... which apparently your Combo Boxes are, apply to all the
copies. Bound Controls, that is, controls which have a Control Source in the
Form's Record Source, will display the data in their Control Source.

Larry Linson
Microsoft Access MVP