>I have an SQL passthrough program that creates a cursor from a remote source. I use this cursor in a form to display data. Now also in my form I have a table referenced with the same name that has local data. I can look at the remote data ok or the local data ok first. But when I try to change from one to the other I get an error because the one is not releasing properly. I do a close/open tables when a textbox is clicked but it dosen't seem to release all the tables.

You better use a different name for the 2 tables...