I am stuck on a problem!

I have a table containing line items which are appended to another table using Append Query. But in the table being appended to I have a field 'QuoteRef' and i need to append a value from a form into this field but am stuck how to do this.

Assuming the form is based on another table, why not write a second append query and run that.

It may also be faster to use the code [QuoteRef].value = Me.tag code to collect the value to use in the 1st Append Query where the QuoteRef field is given the value Forms![Formname].tag

Hi Ted, I gave the post the wrong title; i should have expressed sending a form value to the append query. When i generate a quote the form displays a new quote reference. I pull line items from a static table into my quote items table using the append query. But i need to also take the quote reference from the form and apply it to the line items being appended to bind it together.

here is a picture of my query designer