>Hey folks...
>
> This should be stupid simple, but I seem to be just stupid...
>
> I have a list box on a Form Tab with a Row Source Type of "Array" and the Row Source of the array "ThisFormSet.so_FS.sa_Images".
>
> On the record selection, I want to fill it in with the results from a SQL Select:
>
> SELECT PADR(JUSTSTEM(imgfile), 25) AS stem, imgfile FROM a_arcimg WHERE custno = a_arcust.custno INTO ARRAY laImages
> IF _TALLY > 0
> = ACOPY(laImages, ThisFormSet.so_FS.sa_Images)
> ELSE
> .sa_images[1] = ""
> ENDIF
>
> ThisFormSet.frmCustomer.CntpgfCustomer.PgfMain.page9.CntTaxCert.LstImages.Refresh()
>
> When I do this, I only get results from ONE record, even though the array has all of the information for all records. Why don't I get more?
>
> Thanks in advance!
ACOPY() can to do trouble.
try
SELECT PADR(JUSTSTEM(imgfile), 25) AS stem, imgfile FROM a_arcimg WHERE custno = a_arcust.custno INTO ARRAY .sa_Images
IF _TALLY = 0
DIMENSION .sa_images[1]
.sa_images[1] = ""
ENDIF