Hi Mark,
Try with this replacing with your own statements.I hope help you.
nSQL = "SELECT " + THIS.display_column + "," + THIS.return_column + " FROM " + THIS.lookup_table + " ORDER BY " + THIS.order_column + " INTO CURSOR " + THIS.name
Thanks in advance