Filter by form.

[Craigy Boy]

In access 97 I have created a form that I use to do a filter by form query on. It works fine until I exceed 1000 records in the table. It then returns the Null and Is Null options on the drop down menus. What have I done wrong?

 

[LQ]

I had something similar happen to me, although it didn't have any relation to the number of records in the table. I changed the property Filter Lookup to "Always" for that particular text box, and now when I filter by form it displays a list of previously entered values for that text box instead of null/is not null.

HTH