I have a form with a subform. The records in the subform can be "Edited" but new records cannot be added to it within the subform.
To add records I have created 8 floating fields on the main form that coincide with the subform fields. These floating fields do not have control sources however I have a "Add a Stat" command button that runs a macro to append the data from the floating fields to a table. The macro also turns off the Warnings before the append query runs and then turns it back on after the append query.
Below is vba in the "Add a Stat" button. After the macro runs I need vba to requery/refresh the data in the subform.
Could you tell me how to do this?
Master form Name: frm_DailyStats
Subform Name: frm_DailyStatsSubform
Private Sub AddAStatisctic_Click()
On Error GoTo Err_AddAStatisctic_Click