I have button on main form which calls Macro (mcrInitiateAllRecs) that utilizes ApplyFilter Action Command to call another query (qryInitiateMOCAllRecs) to display all records.
Upon clicking button, the form does not refresh to show all records. (ie. Record: |< 1 of 20394 >|).
I've single-stepped through macro and the dialog box shows arguments as: qryInitiateMOCAllRecs,,
From my understanding, this should be not passing any filter criteria to the query, so it should return all records.
BTW...the query does not contain any filtering logic in the SQL either.
Why is this macro not operating as designed?
Is there some hidden filter that is being passed to query that I am not aware of?
Any help would be greatly appreciated.
MsBecca23