K
kealaz
On my form, I have a combo box w/ the following properties.
Row Source Type: Table/Query
Row Source: SELECT table001.item1, table001.FIELD1, table001.FIELD2,
table001.FIELD3 FROM table001;
column count: 4
column widths: 2"; 0"; 0"; 0"
This combo box is working correctly and giving me the results I want. I
checked by giving the 2nd, 3rd and 4th columns width, and the results are
there and correct.
The next combo box is the one I am working on and asked about in my original
post. I want the values in column 3, 4 & 5 of the first combo box to be
selections in this second combo box, such that the choices are
[value of FIELD 1]
[value of FIELD 2]
[value of FIELD 3]
How do I make this happen? Would I use After Update on the first box? or
Row Source on the second combo box. Can my source be a control in the same
form? What is the code to make this work?
I hope this makes more sense. THANK YOU so much for your help with this.
Row Source Type: Table/Query
Row Source: SELECT table001.item1, table001.FIELD1, table001.FIELD2,
table001.FIELD3 FROM table001;
column count: 4
column widths: 2"; 0"; 0"; 0"
This combo box is working correctly and giving me the results I want. I
checked by giving the 2nd, 3rd and 4th columns width, and the results are
there and correct.
The next combo box is the one I am working on and asked about in my original
post. I want the values in column 3, 4 & 5 of the first combo box to be
selections in this second combo box, such that the choices are
[value of FIELD 1]
[value of FIELD 2]
[value of FIELD 3]
How do I make this happen? Would I use After Update on the first box? or
Row Source on the second combo box. Can my source be a control in the same
form? What is the code to make this work?
I hope this makes more sense. THANK YOU so much for your help with this.