Combo Box dependent on Another

[springwood01]

although I know how to do this, I usually have to do it a couple of 3 times to make it work. Can someone explain to me why when I make a selection in combo box one, and then go to combo box 2 and select a name proper for the Box 1 selection, this same selection appears on all suceeding pages? In other words, whatever name I select on a record in box 2 will appear on all other forms. Here is what I have:

Combo Box 1 - unbound, Name = PickCategory

SELECT Categories.Category
FROM Categories
GROUP BY Categories.Category;

Combo Box 2 - unbound, Name = cboName

SELECT Categories.Name, Categories.Category
FROM Categories
WHERE (((Categories.Category)=[forms]![Issues]![PickCategory]));

Combo Box 2 - Code Builder
me.cboName.requery

 

[springwood01]

OK, I figured out myself. Instead of having the combo boxes as unbound, I bound them to their field name and that seems to do it. Confuses me a but since most instructions tell you to keep them unbound.

Sorry for the premature posting. I had tried everything but this one change.

Case closed.