I agree with you guys on the filter options but users usually need a straight forward way to do things, they will not know about some built in tools. I would suggest a combo box at the top of form that has "Open Orders" and "All Orders" and in the AfterUpdate of that combo field, set the RecordSource of the form.
If me.cboSelect -= "Open Orders" thenForms!MyForm.Recordsource = "Select * from MyTable Where Status <> Complete"
Else
Forms!MyForm.Recordsource = "Select * from MyTable"
End IF
Forms!MyForm.Requery