Subform to act like Listbox

K

kabaka

Hi

Could someone provide me with some instruction as to how I might have a
subform act like a multi-column, multi-select listbox. (My reason for doing
so is that I have found it virtually impossible to format a list box.)

Here are the details:
My subform is a sql based continuous form with a dozen or so bound text
boxes. I would like to be able to "click" on one (any one) of the text boxes
within a row and have the entire row appear selected. In addition, I would
like to be able to simulate the multi-select property of a list box.
Finally, I would like to be able to store (in a variable string or array) the
"adjustment_number" (a non unique number) of the selected row(s).

Any help or am I just wishful thinking?

Thanks!
 
Top