Access vba stop screen updating
To perform those tasks, you can requery the records.
However, I *can* change the Screen Updating from the immediate window. Screen Updating = False b Global Change Event = True Application. About to go home for the day, but I plan on trying to print Application. So while Screen Updating always is True in debug mode, this is not the issue for me.
However, you can immediately display the most current data by refreshing the records.
You can also perform a more thorough update by requerying the data.
What happens is that it grabs the sequence number, finds the next in sequence and gives it a new sequence number (existing number -1) and gives the selected record a new sequence number (existing number 1).
I now need to resort them so can use refresh which leaves the cursor on the selected record. If I wanted to move down twice, I would have to find the record and select it again with requery. This is used to refresh the screen without interacting with the database. Say you have a label “Update Processing” to warn users that a lengthy process is happening.