Filter by form with linked tables

D

Danny

Using Filter By Form on a particular form, some fields only show "Is NULL"
and "Is Not NULL" in the pulldown. I've already set the Filter Lookup option
to retrieve up to 900,000 records for lists.

Turns out I recently split the database. So I then tested this form using a
local (non-linked) copy of the relevant table, and sure enough, when in
Filter By Form, pulldown lists for the fields in question now show actual
data values instead of "Is NULL" and "Is Not NULL".

Is there something else I need to do to get this to work properly using
linked tables?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter-by-form and Linked Tables 0
Filter by form in linked table database 2
Form filter combo box choices are Is Null/Is Not Null 3
DatePart in Filter By Form field 0
Filter by Form problem 2
iif exists - too complex? 0
How do I clear a form? 0
Filter by form search field showing non-distinct values in pull do 1

Top