Correct query not working on form

[Brian Martin]

I have an update query that works perfectly well on it's own but when I call it via a button on a form using openquery it doesn't update the table. I have checked that the names of the control referred to in the query are correct. Why is this???

 

[Tracy]

What is the exact code on your button that calls the query to run?