Hi,
I'm trying to update a table using a form bound to a query:

select a.pid, a.bid, b.selected
from customers as a left join providers as b on (a.pid=b.pid) and (a.bid=b.bid)


in one computer it works, and wen I click on the selected (a yes/no field) it updates the providers table. However, when I try it in another computer it does not work. Any ideas??

Thanks,
Margarita

Since you are presenting a SELECT statement I will assume you are trying to update a Table contained within your windows form and not a database table.

I really don't have an answer to this since there is nothing profound in the SELECT statement or in your description that points to a problem. Since, I assume, you are working with a windows application do both machines have the most updated version of the application? Are you silently handling errors which may be covering up the problem? (By silently I mean using a Try Catch block where the catch block is empty thus your error is never dealt with).

Very strange indeed.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Yes, I'm trying to update the field bound to the checkbox in through a form. No error handling -pretty basic form. Need to check versions, though.

it works on Access 2003 although dbatase is saved as Access 2000. I have access 200 in my computer and it doesn't work. It should if in the other computer is saved as access 2000, shouldn't it?

Hi All,
Seems like the problem's solved. The only requirement for the query to work is that all the tables in the query must have a primary key, otherwise the underlying recordset generated by the query is not updatable.

Margarita