Append Query with new values (1 Viewer)

Hi,

I have a form which gives me my outstanding ledger to which I can make payments against and creates a payment basket (which has a unique reference) in a temp table prior to posting.

What I want to do is run an append query that appends an exact copy of all records relating to that basket apart from a few key fields which I want to give new values (based on a field in the form).

Any help would be appreciated.

just specify in the query the control name on the form to insert:

arnelgp said:

just specify in the query the control name on the form to insert:

Code:Copy to clipboard

Insert Into TableName (Field1, Field2, Field3 [, FieldX]) 
SELECT [Forms]![FormName]![ControlName], Field2FromTempTable, Field3FromTempTable [, FieldXFromTempTable]
FROM TempTable;

Click to expand...

Hi arnelgp,

Sorry for the delayed response. Thats fab, ill be trying it this week. Much appreciated.