>I repeat these six lines of code 30+ times in my Form Init. Can I shorten it instead of repeating it 30 times with the only difference being a different SCAN FOR = code and a different array name in each of the 30+ sets of code?
>
>I did it this way so I could add to my lookup table without modifying the PUBLIC ARRAY size every time I did an add to my lookup table. My lookup table contains comboxbox items to populate most comboboxes on my forms.
>
>ii = 0
>SELECT lookup
>SCAN FOR code = 15
>ii = ii + 1
>ENDSCAN
>PUBLIC ARRAY asite(ii,2)
>
>Then, I wouldn't have to count the items in the lookup table to know the array size. I would think there is a better way than this way. How about it? Help please. Thanks.

Steve,

First, look at the syntax for COUNT TO.

Second, I assume what's going on here is that you're populating the array with values in one of the lookup tables fields. If so, you can declare the array, DIMENSION it to 1, then issue SELECT Field FROM lookup WHERE code = 15 INTO ARRAY asite.

Third, I assume that this is occurring multiple times because of multiple values of the code field. If so, I'd make it (one occurance) a method and pass the code number and array as parameters.