Gary
So what exactly is your problem? You want the data to be displayed but to be updateable? If you WANT to display the data in a grid can't you read it from the array into a cursor, and have this as the source of the grid?
If you're happy with (or prefer) a listbox then what is the code you've tried to populate the box, that gave you the grey square?
Terry
>I need to display data from an array list in one column of a grid.
>
>The table contains an index to the array, so a row has a number between 1 & 6 that relates to one row in the array. I can display correctly using a combo box with the array as it's RowSource, but this gives me a drop down arrow and in the instance the users can not change the values.
>
>I've tried a listbox, which gives a grey square instead of a drop down arrow (not a great improvement!). I could create 6 textboxes in the column and set the correct one with a DynamicControl setting but I have another instance with 99 possibles, so I don't think thats an option.
>
>The old version of this system stored the text value in another field in the table, but this means maintaining duplicate data, which I do not want to do.
>
>Am I missing some blindingly obvious solution? any ideas?
>
>
>Gary Williams
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.