H
hngo
can anyone please help,
I have follow the sample form access 2000 to set two combo boxes to
synchronize. Howevr this only work for the first time whem you open the
form. After that doesn't matter what you change in combo box one this does
not change the record in combo box 2.
these are what i have done.
!) the combo box 1 set with an unbound field naming "test" the row sources
are pointing to table name "order number". The coding is as follows for
after update
me.test.requery
2) the combobox 2 has name set to "order" and control source also to "order"
the row sources with three fields. One of the field is "order number" to be
set with criteria =[forms]![order number]![test]
many thanks inadvance
I have follow the sample form access 2000 to set two combo boxes to
synchronize. Howevr this only work for the first time whem you open the
form. After that doesn't matter what you change in combo box one this does
not change the record in combo box 2.
these are what i have done.
!) the combo box 1 set with an unbound field naming "test" the row sources
are pointing to table name "order number". The coding is as follows for
after update
me.test.requery
2) the combobox 2 has name set to "order" and control source also to "order"
the row sources with three fields. One of the field is "order number" to be
set with criteria =[forms]![order number]![test]
many thanks inadvance