Shella
November 7th, 1999, 09:38 AM
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
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