Select query that updates?

[sdave]

Hi,


I have a simple select query with the parameters controlled by a form combo box. The form and query function correctly, but when the query is run (through the form or independently) it updates/changes one record from the table.

The field that is updated is the query parameter field. For example if I query all the records from a city field (Atlanta) I will get all the correct records, but when I go back to my table, one record will now be Atlanta when before it was something else.

Hopefully that description was adequate. The SQL is posted below. I appreciate any help with this problem.

SELECT [Site Tracking Schedule].MSA, [Site Tracking Schedule].Site, [Site Tracking Schedule].Priority, [Site Tracking Schedule].City, [Site Tracking Schedule].ST, [Site Tracking Schedule].Size
FROM [Site Tracking Schedule]
WHERE ((([Site Tracking Schedule].MSA)=[Forms]![Form]![Combo2]))
ORDER BY [Site Tracking Schedule].City;

[pbaldy]

The query can't be changing anything just by being run. My guess is that the combo box is bound to the data, and shouldn't be.

[sdave]

The query can't be changing anything just by being run. My guess is that the combo box is bound to the data, and shouldn't be.

That was the issue. Thank you very much.

[pbaldy]

No problem, and welcome to the site by the way!