I have a popup form to take notes with that opens from a main form. After I enter my notes I want the main form to save the record by itself. Here is my code but it does not save the record on the main form.
If you have a memo field for notes in a sub form, you probably don't need to have the sub form set to a record source.
Try the below, this is basically what I used to move the data from the sub form to the main form, then save the data to the main form.
Private Sub Form_Close()
Forms![frm_main]![NextLetter] = Forms![frm_cupidnotes]![TxtDescription]
Forms![frm_main]![TxtDescription].SetFocus 'Move focus back to main form
Forms![frm_main].Dirty = False 'Save record in main form
This should get you what you need or at least a good start