After working with it more, it seems to be overloaded when I have two tables. It seems strange since in the remote view I can run it, if I right click and do the run query with the remote view open. However, it doesn't seem to work with my form. On the other hand, I can run the code in a prg and it won't work with two tables, but works with the form. So I will just work around it. I'm not sure what the reasons are, but that's ok.
Thanks for your help,
Rex
Rex A. Willis MCSD