Filter By Form

[Fred Zuckerman]

When I use the standard "Filter By Form" button, each control is usually a
combo box with the preset choices of "Is Null" or "Is Not Null". But
sometimes a control will be a combo box with the preset choices of every
unique value that exists for that control in the unfiltered record source.
Does anyone know what circumstance lead to these 2 different scenarios?
TIA,
Fred Zuckerman

[Bruce Dodds]

Fred Zuckerman wrote:

When I use the standard "Filter By Form" button, each control is usually a
combo box with the preset choices of "Is Null" or "Is Not Null". But
sometimes a control will be a combo box with the preset choices of every
unique value that exists for that control in the unfiltered record source.
Does anyone know what circumstance lead to these 2 different scenarios?
TIA,
Fred Zuckerman

Funny you should ask, because I just had that problem today in A2003.

You can try two fixes. One is to change the maximum number of records to
display for any QBF field (default is 1000). The other is to change the
value of the FilterLookup property for the combo box to "Always".

These options are described in Help for the FilterLookup property.

(I just had a case where changing the default maximum number of records
didn't work, but changing the FilterLookup property did).