Derek
SQL select the table into an array and have that array as the RowSource.
Or have the rowsourcetype as 0 (none) and use combobox.AddListitem etc to populate the combio from your array.
HTH
Terry
>Hi,
>
>I want to ask how to load a single table to a combobox control BUT
>the RowSource of the combobox is 5-Array. I don't want the combobox control
>link with the table.
>
>Please advise.
>Thanks
>Derek Yim
- 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.