Hi Susan,
You could set the rowsourcetype to 3 and the rowsource to:
SELECT fieldname1,fieldname2... FROM tablename ORDER BY fieldname INTO CURSOR cursorname

HTH