Well I set the RowSource to ThisForm.aResults and RowSourceType to 5
My code to load the list now looks like:
SELECT TRANSFORM(Id) AS Id,;
StatName,;
ProgTitl,;
ClientId,;
BkPhone,;
DTOC(BkDate) + " " + BkTime AS DateTime,;
TRANSFORM(BasOrdr) AS OrdQty,;
State;
FROM Resh;
WHERE ALLTRIM(ClientId) = "GM";
INTO ARRAY aResults
=ACOPY(aResults, .aResults)
.Refresh()
and now all I get is 1 row in he list.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people