I once had this problem before, i didnt want to struggle with it forever, so i set it up on the click of the save button, that the form would acCmdSaveRecord, then it would close the form, then reopen it. Theres probably better ways like a me.form.refresh then a Me.subform.refresh then requery...