... .. don't forget to clear your filters like this oRs:Filter := "" Clearing the filter will re-set the recorset and give you back access to your origional 'fetch' oRs:Requery() is a useful tool as well as oRs:ReSync(1,2) .. do not leave the resync parameters out .. and you MUST have a 'primary ...