combo list problem
I used VBA to hardcode the rowsource of two combo fields, they’re both value lists. When one of my users requested additional codes to their region I inserted the applicable data in both controls. Basically a user selects a code in one combo & the other combo fills automatically, the 2nd combos is locked & cant be accessed, I couldn’t think of any other way to accomplish the task of showing one thing in the rowsource & storing something else in the mdb.
So anyway, even though I’ve hard coded the rowsource for both controls, selecting the new codes I’ve inserted from the first combo, will not bring up the applicable data hardcoded into the 2nd, locked combo box, it works for all the original set of data though.
I used VBA to hardcode the rowsource of two combo fields, they’re both value lists. When one of my users requested additional codes to their region I inserted the applicable data in both controls. Basically a user selects a code in one combo & the other combo fills automatically, the 2nd combos is locked & cant be accessed, I couldn’t think of any other way to accomplish the task of showing one thing in the rowsource & storing something else in the mdb.
So anyway, even though I’ve hard coded the rowsource for both controls, selecting the new codes I’ve inserted from the first combo, will not bring up the applicable data hardcoded into the 2nd, locked combo box, it works for all the original set of data though.
