update query problem

[mohammadagul]

hi, i am having a little difficulty in making an update query.

table : tblQuote
fields : quoteno, quotedate, customerid, customername

table : tblInvoice
fields : quoteno, quotedate, customerid, customername , invoiceno, invoicedate.

i want to update tblinvoice from tblquote from form frmquote.

i want to update only one record ata a time. also i dont want to delete previous quote records in tblinvoice so i placed the following criteria in the update query.
[forms]![frmQuote]![quoteno]

but it is not updating my records.

even if it does update it is overwriring me previous records in tblinvoice.

any suggestions

 

[MStef]

Hello Mohammadagul!
1) You don't need the same data in the two tables.
2) What do you want?
Update an existing record or ADD a new rec.
If you want to ADD a new rec. use an APPEND
query, not Update query.

 

[mohammadagul]

i want to transfer data from one table to another table.

this is entirely business thing i am going to tell you. the company first send quotes to the customers. if everthing is gone well that an invoice is issued against that quote. now what i wanted to do was that the company will send the customer a quote. upon receiving a response we will know whether to issue an invoice or not. so instead of using the a new invoce i want to convert that paticular quote to invoce.

thus deleting a record from quote table and adding the same thing in invoice table.

i hpe you get the picture.

 

[MStef]

Ok, Then use APPEND query, not Update query.