By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

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

P: 1
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]));
Apr 12 '12 #1
Share this Question
Share on Google+
2 Replies

P: 10
I don't think you can stop your query from updating in the table because the query is based off of your table.
Apr 12 '12 #2

Expert Mod 100+
P: 2,321
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.
Apr 13 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.