No filtering if a text box has a Null value. (1 Viewer)

[Snuggle Walrus]

Hi! Quick question I want to run a query that used as a datasheet table as a subform. I'd like the sheet to display all records if a CustomerID box is Null but filter IF the box has a value to just that customer ID. Is this possible? Thankyou have a fantastic day!

 

[plog]

Make a calculated field in your query, don't show it, but use it as criteria:

ShowRecord: Iif(Isnull([Forms]![YourFormName]![CustomerID]) OR [Forms]![YourFormName]![CustomerID]=[CustomerID], True,False)

Then under it make the criteria True.

 

[Snuggle Walrus]

Make a calculated field in your query, don't show it, but use it as criteria:

ShowRecord: Iif(Isnull([Forms]![YourFormName]![CustomerID]) OR [Forms]![YourFormName]![CustomerID]=[CustomerID], True,False)

Then under it make the criteria True.

Works beautifully! Thanks so much mate! Exactly what i needed! Have an awesome day !