Girl
Nov 9th, 1999, 09:01 PM
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)
How to prevent [ProductNameCombo] and [CategoryCombo] of other records on a continuous form from changing ?
If u want, I can email u my Access database.
Really need ur help, 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)
How to prevent [ProductNameCombo] and [CategoryCombo] of other records on a continuous form from changing ?
If u want, I can email u my Access database.
Really need ur help, thanx in advance