Hi
I've snychronized 2 Combo Boxes on a
Continuous form in Access 97, if there are six records listed on the form, when I change the value of a ComboBox1, the ComoxBox2 will then reflect the changes of ComboBox1, but all the ComboxBox2 (as in Continuous form) will change as well. How can I limit the relection only applied to the ComboBox2 of the Current Record on a Continuous form ?
The following codes are the sample of my 3 ComboBoxes' synchronization.

Private Sub ProductCodeCombo_AfterUpdate()
Me![ProductNameCombo].Requery
Me![CategoryCombo].Requery
Me![ProductNameCombo] = Me![ProductNameCombo].ItemData(0)
Me![CategoryCombo] = Me![CategoryCombo].ItemData(0)

Thanx in advance