Same as if you change a value on a line previous, just changing the value is NOT going to set the new value. You need to press Enter again for it to take.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba