Refresh open table

[Rod C]

I have a test database with an open table. I want to run an update query and then see the results in the open table. What code or method do I use to refresh the table. I can use the menu item “Records & Refresh” but I can’t figure out how to run that in code. I may need to set focus to the form first but don’t know how to accomplish that. Any ideas?

 

[Rich]

Why is the table open?

 

[Rod C]

So that I can view the records before and after the update query is run.