F
frank
I am using access 97 and have run into an odd problem. I
have created a combo box with a drop down list based on
a "value list". the combo box has a "column count" of 3.
I set the row source to the following string:
xx;yy;zz;xx;rr;zz;xx;vv;zz;vv;rr;zz. With this string I
get 3 rows with 3 columns that begin with "xx" and 1 row
that begins with "vv". When I select row1 i can retrieve
column(0), column(1), and column(2) values in code (column
1 is xx..column 2 is yy..column 3 is zz). However when I
clik row 2..(should be xx;rr;zz) visual basic will only
return row 1 (i.e. column(0)="xx" but column(1)="yy"
SHould be "rr") information. It is only when I switch to
a row that has a different column(0) value that it
retrieves the data properly (i.e. when i go to
row "vv" ... I get a return value for column(1) of "rr"
and column(2) of "zz"). I know this is a confusing
statemnt....Anyone have any idea what is going on....
have created a combo box with a drop down list based on
a "value list". the combo box has a "column count" of 3.
I set the row source to the following string:
xx;yy;zz;xx;rr;zz;xx;vv;zz;vv;rr;zz. With this string I
get 3 rows with 3 columns that begin with "xx" and 1 row
that begins with "vv". When I select row1 i can retrieve
column(0), column(1), and column(2) values in code (column
1 is xx..column 2 is yy..column 3 is zz). However when I
clik row 2..(should be xx;rr;zz) visual basic will only
return row 1 (i.e. column(0)="xx" but column(1)="yy"
SHould be "rr") information. It is only when I switch to
a row that has a different column(0) value that it
retrieves the data properly (i.e. when i go to
row "vv" ... I get a return value for column(1) of "rr"
and column(2) of "zz"). I know this is a confusing
statemnt....Anyone have any idea what is going on....