I have a query that I have set up to returns all data  (See illustration attached for query details) until a filter is applied through unbound text boxes on the form.
The user has asked for 2 additional fields to be added however there isnt any data in those fields from the past. I added the search criteria to the query however it didnt work until I added zeros to all the empty fields. I tried adding the NZ function to my query criteria however after making that change, my form is empty not returning any data until I enter a criteria on one of the text boxes. I have only used the NZ a few times so I am sure I dont have it configured correctly.

This is one of the ways I tried to use NZ
Like "*" & Nz([Forms]![KFHOANavigationFF]![NavigationSubF].[Form]![txtCheckNbr],0)