Problems with query by form

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

In my database when I opened query by form, a drop down
list with all the entries for a particular field would
appear and I could select whatever one was relevant and
apply the filter. However something has changed recently
and now all that appears when I click the down arrow
is "Null" or "Is Not Null" for every field. How can I get
it to return to the full selection. Any help would be
appreciated.
Thanks
Michael
 
That is a setting. Normally, the setting works within a limit of 1000 records
and then after that it just displays the two choices.

The settings are under
Tools: Options on the Edit/Find Tab
 
Back
Top