Shih,

You ahve no garuantee what recno() will return inside the sql. Don't use recno(), instead select the primary key from the table. If the table doesn't have a primary key then give it one, because sql is designed to work on relational databases and in RDBMS there is ALWAYS a primary key.