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
RICK, I went to the Tools/Options area and changed the number in that box
from 1000 (default value) to 10000 since I don't think we'll reach that value soon. That did not help. The values that show in a field in the Filter by Form still only show IS NULL, IS NOT NULL. Donna wrote: I have a table within a database that I want to filter. However, when I choose Filter/Filter by Form and click the drop down menus in the fields I want to use in the filter, the only options are IS NULL or IS NOT NULL. EXCEPT for only one of the fields which gives me a list of the options that match the values in that field. How do I set up my table so that I can filter for data in ANY of the fields? Tools - Options - Filter By Form Defaults "Don't display lists where more than this number of records exists" |
#2
|
|||
|
|||
Donna wrote:
RICK, I went to the Tools/Options area and changed the number in that box from 1000 (default value) to 10000 since I don't think we'll reach that value soon. That did not help. The values that show in a field in the Filter by Form still only show IS NULL, IS NOT NULL. Apparently it works exactly as advertised, but only if the table is local (it cannot be a linked table). -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing Report on Recordset Using "Filter by Form" - Error Messag | Stepney_Clint | Setting Up & Running Reports | 0 | January 7th, 2005 08:17 PM |
Filter By Form using LIKE clause | SirPoonga | General Discussion | 6 | December 9th, 2004 11:22 PM |
Rut Roh Filter by Form | LMB | New Users | 15 | November 19th, 2004 01:04 PM |
Stop saving the filter entered by the user | ConnieA | Using Forms | 13 | July 30th, 2004 06:07 PM |
Filter Problems on Main form & Subform | Jeff | Using Forms | 2 | July 7th, 2004 03:13 PM |