I have a query that returns the warehouse location for an item based on it's item number. I created a form that allows you to enter several different items numbers, so that the final result is a list of several items with their locations.
I am entering the form fields into the criteria row at the bottom of the query using the OR function ([Forms]![Location Search Form]![Text0] Or [Forms]![Location Search Form]![Text2] ....) I can get it to come back with results on the first 12 inputs, bot not the rest. I can get the entore list if I run the wuery at the same time I enter them, but when I colse and reopen the qyery the last half are missing.
Is there a limit to the number of Or functions I can list?
Thanks,
David
I am entering the form fields into the criteria row at the bottom of the query using the OR function ([Forms]![Location Search Form]![Text0] Or [Forms]![Location Search Form]![Text2] ....) I can get it to come back with results on the first 12 inputs, bot not the rest. I can get the entore list if I run the wuery at the same time I enter them, but when I colse and reopen the qyery the last half are missing.
Is there a limit to the number of Or functions I can list?
Thanks,
David