I have created a Table with just 3 Fields (ID, Number, and True/False).
I populated it with the numbers 1-5000, as users are going to select a number in this range from a Combo Box.
If the True/False Field is set to True, then the numbers shouldn't appear in the Combo Box, so I've created a Query that Selects these 3 Fields and have added 'False' to the T/F Criteria.
HOWEVER! . . . Access ignores the first 255 Records and only returns Records 256 through 5,000, even though there are just 3 numbers in the whole 5,000 with a True Condition.
Does anyone know why Access would ignore the first 255 Records?
I'm completely spun-out!
Thanks for any advice.