>I normally use the NOT DELETED() function in my Select Statement right after deleting a record and then refresh the recordsource to capture the updated information into the cursor.

Use SET DELETE ON setting so you wouldn't need NOT DELETED() in your select. Anyway you cannot use NOT DELETED() in multi-table select because it may produce incorrect or unexpected results.