Update Query?

[snagrat]

I cuurent have two tables which store my data.

When a command button is clicked on my form I want all the data from one table to be moved to the other. I thought about using an Update Query however this does not work.

I design it using QBE, but here is the SQL of the query:

UPDATE tblTemp, tblInvoice SET tblTemp.CustomerID = tblInvoice!CustomerID, tblTemp.ProductID = tblInvoice![Product ID], tblTemp.Quantity = tblInvoice!Quantity, tblTemp.Price = tblInvoice![Price Each], tblTemp.[Line Price] = tblInvoice![Amount exVAT];

Anyone see why this is not working?

 

[KevinM]

Try an Append query.