How do I stop my query from updating records in a table?

[skibumlove]

I am using the following query to generate a report in Access 2007. I want the query to ONLY select records for the report. When I execute this query a new record is inserted in the table. How can I get this code to stop updating the table it is reading from?

Thank you.


SELECT tblFormData.FormID, tblFormData.StudentNumber, tblFormData.SchoolYear, tblFormData.SchoolCode, tblFormData.SportName, tblFormData.ParentSignature, tblFormData.CoachSignature, *
FROM tblFormData
WHERE (((tblFormData.ParentSignature)=[forms]![frmSign]![chkParent]) AND ((tblFormData.CoachSignature)=[forms]![frmSign]![chkCoach]));

[annie8508]

I don't think you can stop your query from updating in the table because the query is based off of your table.

[TheSmileyCoder]

Hi and welcome to Bytes.

That query will not generate any new records. However if you view the query results directly (i.e not in your report) you might see a blank template for a new record appear at the bottom. Unless you start typing in that last line, no new record will be created.