Hi all.
I believe i have somewhat a little stupid question, but I hope I have some understanding - I'm just totally stuck here.
The case is:
Two different combo boxes with the following setup:
cboBox1, Control Source to a valid field in underlaying table:
Row Source: "Horizontal";"Vertical"
Row S Type: Value list
cboBox2, Control Source to another valid field in underlaying table:
Row Source: "Power";"Signal";"High Volt"; Common"
Row S Type: Value list
In table both columns shows the correct data according to the Value lists. (added manually test data) Then, when creating the two mentioned combo boxes in the form, the cboBox2 are showing the value list from cboBox1. The cboBox1 are showing the expected values. I have changed the Row Source Type to Query, deleted the value list and the cboBox2 of course shows nothing in form view. Changing back to the values list mentioned above in Source and switching back to Value List, and the cboBox2 are back showing the value list from cboBox1 instead of the value list which are clearly made for cboBox2.
So, just for testing, changing the Control Source of cboBox2 to a third valid table field, and suddenly the correct value list are displayed inform view.
All three fields in the table are of nvarchar() type. All three are having some test data with the correct according to wanted value lists. Btw; created a third combobox for the third field in the table with a value list, and this is show correctly the value list...
Then - for the sake of testing, I switched the underlaying table field for cboBox1 and cboBox2 - and surprisingly, the value list in form view where also switching despite the fact both cboBox1 and 2 have the opposite value list (original) in the setup.
Backend is SQL server table.
Regards, Geirr.
I believe i have somewhat a little stupid question, but I hope I have some understanding - I'm just totally stuck here.
The case is:
Two different combo boxes with the following setup:
cboBox1, Control Source to a valid field in underlaying table:
Row Source: "Horizontal";"Vertical"
Row S Type: Value list
cboBox2, Control Source to another valid field in underlaying table:
Row Source: "Power";"Signal";"High Volt"; Common"
Row S Type: Value list
In table both columns shows the correct data according to the Value lists. (added manually test data) Then, when creating the two mentioned combo boxes in the form, the cboBox2 are showing the value list from cboBox1. The cboBox1 are showing the expected values. I have changed the Row Source Type to Query, deleted the value list and the cboBox2 of course shows nothing in form view. Changing back to the values list mentioned above in Source and switching back to Value List, and the cboBox2 are back showing the value list from cboBox1 instead of the value list which are clearly made for cboBox2.
So, just for testing, changing the Control Source of cboBox2 to a third valid table field, and suddenly the correct value list are displayed inform view.
All three fields in the table are of nvarchar() type. All three are having some test data with the correct according to wanted value lists. Btw; created a third combobox for the third field in the table with a value list, and this is show correctly the value list...
Then - for the sake of testing, I switched the underlaying table field for cboBox1 and cboBox2 - and surprisingly, the value list in form view where also switching despite the fact both cboBox1 and 2 have the opposite value list (original) in the setup.
Backend is SQL server table.
Regards, Geirr.