Hi,
I have read a lot about the issue. The problem is that when you have one combo box (cbo1) filtering another one (cbo2) on a continuous form, making a change on row2 will affect what appears in row1 cbo2 (even if the record on in the table is not affected.
What I don't understand is why when the primary key is selected in cbo2 the problem does not trigger.
E.g.: My cbo2 has 4 columns (itemID, itemName, CategoryID and BrandName):
- If set column width to 3,3,3,3, the problem does not trigger but I only see numbers in my cbo2
- if I set column width to 0,3,0,0, the name appear in cbo2 but then the problem triggers and these names start appearing and disappearing as I select combo boxes on different rows.
Any expert to explain why?
I have read a lot about the issue. The problem is that when you have one combo box (cbo1) filtering another one (cbo2) on a continuous form, making a change on row2 will affect what appears in row1 cbo2 (even if the record on in the table is not affected.
What I don't understand is why when the primary key is selected in cbo2 the problem does not trigger.
E.g.: My cbo2 has 4 columns (itemID, itemName, CategoryID and BrandName):
- If set column width to 3,3,3,3, the problem does not trigger but I only see numbers in my cbo2
- if I set column width to 0,3,0,0, the name appear in cbo2 but then the problem triggers and these names start appearing and disappearing as I select combo boxes on different rows.
Any expert to explain why?
