Display updated table through a subform
Posted on 2016-11-04
I have an Access form with a subform on it whose records source is a table. The table's contents get displayed in the subform.
I have a query that updates the table displayed in the subform. Actually what the query does is adds records to or appends the table.
The query gets invoked by clicking a command button.
After I run the query, how do I get the updated table to display in the subform?
I think it's something like Docmd.Requery but if that's what it is, where do I put it? Or if it's something else entirely, please let me know.