runtime err 2118 you must save before requery

[Mark]

Hello all,

I have a form with a sub report. In the sub report (over table) I have a
field that is a yes, or no type. In the form I allow them to select which
item they want ran by selecting this field. I also have a button that
automatical selects all (code below).

DoCmd.OpenQuery "qrSelectAll" ' Query select all
sbSel.Requery

Everything works great unless they select one or more manually then push the
"select all" button then I get the 2118 error.

Question:
I have tried to save the file prior to running this code but it is not
working. How do i save a sub report over a table ?

Here's code I tried

DoCmd.Save acForm, [sbSel]
acDefault
acTable, etc. I have tried them all, but nothing.