I am a bit of a neophyte in access programming so be gentle please. I am adding a simple form to my QC database to pick records fulfilling several criteria. It is basically a query for those who cannot make a query, populating an unbound listbox based on values entered in the form from a query referencing the form values (I know there are likely quicker and easier ways to accomplish this but they are beyond my skills.)
One example criteria field in the query is "<=[Forms]![RCForm]![VOLMAXBOX]" The idea is to change the railcars in the listbox depending on the values entered in the form to ship to customer specifications.
The numerical field [VOL] contains mostly 0's with a few values under 100 here and there in multiples of 4. The strange thing that is happening is when I have the field set to 4 I get 80 records returned. 3 and 2 return 80 records. When I reduce the field to 1 or 0 the list box is empty (again, all values are multiples of 4 so 80 should be returned.) I can design a query and return the 80 records using <=1 or 0 in the criteria field.
Why would a listbox occasionally fail to return values that a direct query returns?