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.

Try using columns in your combo box. Set Column 1 as the Bound COlumn and set it's width to 0". Then display the column with the data you want visible with a column width of 1".

This way, the user sees column two, but column one is stored in the table.

[This message has been edited by scottfarcus (edited 10-15-2001).]

well, yeah sorry I didn’t mention before, but that’s how my combo’s were setup, the bound column hidden in both controls.