Originally Posted by
Gicu
Open the query designer and add both the table and the query, join them by CustomerID and make the query an Update query (by clicking on the ribbon).
Should look something like this (adapt to match your table and query names):
UPDATE TblCustomer INNER JOIN qryCustomer ON TblCustomer.CustomerID = qryCustomer.CustomerID SET TblCustomer.customerFirstName = [qryCustomer]![customerFirstName], TblCustomer.customerLastName = [qryCustomer]![customerLastName];
Cheers,
So I used the above code but I'm getting an error that states "operation must use an updateable query" Any ideas? Below is my exact code:
Code:
UPDATE tableCustomers INNER JOIN qryFix ON [tableCustomers].CustomerID = qryFix.CustomerID SET [tableCustomers].CustomerLastName = [qryFix]![CustomerLastName];