I'll jump in, but be warned - I never caught on to using split forms. Didn't seem as robust as a form subform design. For your problem, I think it's because a split form is a type of datasheet, and in such a form, a control is used multiple times as there are many records. Usually, the controls used to restrict the record set are in the header and the data "list" is in the detail section. You have it reversed.
Even if that is the issue, I don't see this query working. You have Date() as criteria in a date field, yet no records are in there for today's date. You will never return records unless the date there are dates in the table that match whatever day you run this on. Second, I think the field in question in your post is in the wrong query field.
Third, you have MANY fields that are begging to be numbers (quantities, line numbers, taxable amounts, currency...), yet you have set everything to text??
Last edited by Micron; 02-23-2017 at 08:47 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.