I have a sub form that has a combobox. After the combobox has been updated am update query runs which adds records to the record source. But after that happens I want the subform to be refreshed to show all of the records including the ones added via the query.
I'm not sure how to make the subform refresh.
Please note that there is a main form with a subform. The subform I'm trying to refresh is a sub-form on the sub-form that is in the main form.
After the query runs in the VBA code I tried the following but it doesn't work: