akjandu:
Queries are not Tables. They are a view of an underlying table. Anything that you do in the table, or in the query, will normally alter the table. The query will reflect that once it is re-ran.
MS Access 2010 Tutorials
If you have a form based on a query, then the changes made by the user in the form happen IRL. If you have made changes via code, or if in a multi-user environment, you may need to issue a "requery" - this can be done in a few ways such as the
DoCmd.Requery or (the way I tend to do this) is the
control.requery
so in a form I would use
me.requery