>but I also need to get the value of column 1 of the combo box,
>sorry, both column data also need to get in the value.
Instead of using 2 separate columns, maybe you could use just 1, and load it with the combined data. The two values could be visually separated by just a space, or you could use delimiters e.g.
AAA1 AAA2
AAA1 / AAA2
[AAA1][AAA2]
etc.
You would need to parse out the two separate pieces of data from the value you read from the combo.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up