Query changes are vanished !! Very strange

[ariansman]

I have a report. I go to report properties, and open the record source to reach the query on which the report is made. I make some changes to the query. When I close the query it asks me to keep the change or not and I click yes. But when I close the report it doesn’t ask me to keep or discard the changes. Then when I reach to report query again and I see all the changes I have done are gone. This is very strange. What is the problem?

 

[sneuberg]

That is strange. You could try to save the query as a querydef. Maybe that will tell you what's going on. Here are the steps in Access 2013

1. Go to to the properties and edit the query as you have been
2. Click on FILE in the top menu
3. Click SaveAs
4. Click Save Object As
5. Click the Save As Icon
6. In the Save xxxx to: change the query name if you like
7. Click Ok. This will bring you back to the query
8. Close the query
9. When asks "Do you want to save the changes made to the query and update the property? Click Yes

You will now have a querydef that's the record source of the report.
See if the changes stuck in that. If not try changing them in this query.

Edit: What I mean by querydef is a stored query, i.e, what you get when you create a query with the query designer.

 

[pbaldy]

I recall a bug that required you to hit Enter or Tab after closing the query design grid, to move to the next property in the properties window. If you didn't, changes weren't saved.