Select subjobs.subname, subjobs.subnumber from subjobs where empty(subjobs.jobnumber) into cursor curLstSubs

This is the select statement. It does work, it just won't requery.

The where clause of the select statement will change based on user choices but I'm not changing it now just to simplify this debug.

Thanks.