VBA Access Table Not Updating
When modifying access table using VBA, there are times the values being displayed in the table will not update. There is no direct VBA solution to update the values the table is displaying, but there are 2 workarounds:
- Method 1: User manually updates the table
- Method 2: Using userforms
Method 1, Manual Update:
One method would be to manually update the tables values. This can done by either one of the methods below:
- Pressing F5
- Pressing Shift+F9
- Closing and reopening the access database
Note: This is a manual method, not VBA.
Method 2, Using Forms and Requery Function:
In this method, we use a datasheet form, rather than the table itself:
Datasheet forms are forms that look like an Access table. We can then use the forms Requery function to update its values:
Form_MyTable1.Requery
Note: The
object needs to be created. For more information on this please see the link below:Form_MyTable1
You can download the file and code used in this article from the link below:
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com
One thought on “VBA Access Table Not Updating”