Hello All,

I believe I'm still having a problem with Requery() or DIMENSION. I have a form with multiple List Boxes. With Combo1 the user selects a table to be used. With Combo2 the user selects the appropriate order(index), with Combo3 the user select the appropriate Filter and with Combo4 the user selects the report to be run.
The RowSource of Combo1 is fields(only 3 tables). The RowSource of Combo2 is xListArray, The RowSource of Combo3 is fListArray and Combo4 rListArray. xListArray, fListArray and rListArray are all properties of the form. Each array is initially set at DIMENSION xListArray[1]. I have tried the following code in the CLICK property of Combo1 after the user selects the table and also in the CLICK property of Combo2. In both case the ? command indicates that the array has been filled appropriately but only the first array item appears in Combox2. Of course I have the same problem with the other Comboxes . I have spent many hours attempting to resolve this section of code and have referred to many text books. I cant find any examples on how this should be done. Help will be much appreciated.

*
USE LookUp
COUNT TO X FOR Table ='EMP' && Employee table
DIMENSION ThisForm.xListArray[x,2]
SELECT CODE, DESCRIPTIO INTO ARRAY ThisForm.xListArray FROM LookUp WHERE GROUP = 'EMPLINDX'
ThisForm.Combo2.Requery()
? alen(xlistarray)
? xlistarray[2,1]
wait
ThisForm.combo2.SetFocus()
*

Regards,

Paige