If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter-by-form and Linked Tables
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. |
Thread Tools | |
Display Modes | |
|
|