For some reason that I just can't explain, a text box on a form associated
with a single primary key field behaves unexpectedly when I do a
filter-by-form. Instead of listing all of the records from the source table
as choices in combo box mode, I only see "Is Null" and "Is Not Null" as
choices.
I have an older form from another database that behaves as I hoped this one
would, yet there seems to be no property differences between the two text
boxes. Can anybody explain what I'm missing please? Having "Is Null" and
"Is Not Null" as filter-by-form choices just doesn't cut it!
Thanks!!!
Rick Brandt - 24 Apr 2007 01:54 GMT
> For some reason that I just can't explain, a text box on a form
> associated with a single primary key field behaves unexpectedly when
[quoted text clipped - 8 lines]
> doesn't cut it!
> Thanks!!!
If there are too many unique values the list reverts Is Null and Is Not Null. I
think the number is a setting in options.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com