Hello, thanks for any help with the following in advance:

I have created a combobox (dropdown list style) and am trying to use an array as the RowSource. The array is initialized with a size of 1 because it will have to be re-sized depending on selections made by the user.

The combobox has RowSource = aAux2Val and a RowSourceType = 5

In the When Event of the combobox I select the new values for the source array and re-dimension as follows:

SELECT auxvalue FROM auxval ;
WHERE ...
...INTO ARRAY aAux2Val
DIMENSION aAux2Val(ALEN(aAuxVal))
This.refresh

The debugger shows that the data for the control gets selected properly and the array gets re-dimensioned to a length of 4 in a test run. However the control only displays 1 item in the list. I'm assuming this is in conjunction with the fact that when control was created, the initialized array was only that big. I'm having trouble believing that there is no way to re-set the control's ability to display the new values?

This is the third time I have run into this problem and had to fall back to using a cursor. I'm trying to avoid cursors due to possible memory constraints at the end-user level.

Please post any help or e-mail at the address listed below. Thanks.

- Brian