Append Query Error

[AXG]

I made a database to help the office girls with invoices that have to be written (multiple invoices same information). I created a duplicate button to copy my form and sub form onto a new record. The form copies over but the sub form append query comes back with the following error "The INSERT INTO statement containes the following unknown fieldname [Forms]![Orders].Tag" the tag refered to in the query is the Tag Property in the Orders Form. I've been away for awhile and access has moved on without me, I am getting back into it and would be very thankful for any assistance anyone can give.Thank You

 

[Jeanette Cunningham]

In the append query, find the sql and go through the sql and remove the bit which says [Forms]![Orders].Tag

 

[AXG]

Thank you for responding. I am unable to del eat the "f
forms!Orders.Tag" it is needed to input data back into my subform after the new order form is created. For some reason my access 2007 does not recognize the Tag property and will not drop info into it, to be used.

 

[boblarson]

You may not be able to refer to the tag property of the form directly in SQL in 2007 so you can create a function to retrieve it though:

Function GetFormTag(strFormName As String) As String
    GetFormTag = Forms(strFormName).Tag
End Function

Then you can use that in your SQL: