text box filter by form

  • Thread starter Thread starter annie
  • Start date Start date
A

annie

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!!!
 
annie said:
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!!!
Click to expand...

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.
 
Back
Top