Report Problem

[needhelpplz2]

Hi guys,

I've made a report button on my application that is supposed to export results into a pdf file. Here's the weird thing, after it works once if I close it again and try to do the same thing, it gives me a "Run-Time error 3127, The INSERT INTO statement containis the following unknown field name: Expr1". This is for the line DoCmd.OpenQuery("REPORT:APPENDING").

This is the code for REPORT:APPENDING and everything else is named right

INSERT INTO Report IN 'C:\Users\####Name####\Documents\ReportingDb.accdb'
SELECT [REPORT:APPENDED(b)].*
FROM [REPORT:APPENDED(b)];

 

[Ian Rennie]

The term 'Expr1:' is normally the field name created by Access when an underlying query doesn't have the source data for a particular field that did exist when it was first created - if that makes sense?
Ian