Do I recall correctly that a form's RecordSource can't be filtered with simple Filter method? The "early development code" below does not take any effect on the form's RecordSource. (strLastReconcile is a string variable global to the form's module.)
Code:Private Sub cmdShowAll_Click() Me.RecordSource = "QDepositsAll" If strLastReconcile <> "NEVER" Then Me.Filter = "[TDate] >= " & strLastReconcile Me.FilterOn = True End If Me.Requery End Sub