Recent content by Mau5Trap5

In fact the first response answers the problem, I have GROUP BY in one my sub queries, rendering the action query read only. Thanks RuralGuy. I assume creating a temporary table (based on the result of the above SQL) to update the SQL server table would be a work around... UPDATE...

Quite right you are. Not particularly readable, will redo it. Thanks

Hi all, I am trying to update to a SQL table via Access form using ODBC connection. The form has a selection of unbound fields that once populated I wish to be updated to relevant fields in SQL table. I have written the attaced code attached to a button at the bottom of the form. i was...