Subform is not refreshing after update
Posted on 2014-12-21
I have a main form with one subform. The subform is based upon a query and is linked to the main form based upon two fields.
I have a command button on the main form that brings up a second form that allows me to make changes or additions to the table that the query for the subform on the first form is based on. When this form closes the first form again gets focus but the changes or additions made to the table do not appear on the subform. If I move to another record on the main form and then go back to the original record, the changes/additions then show up on the subform.I have tried using the following code to the "On Got Focus" event of the Main form but it does not make a difference:
Any help would be greatly appreciated.