 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / January 2007Unwanted filter
I open a form and it is blank of data except that the record selector in the primary key field (Rec ID) shows AutoNumber. Then when I select Remove Filter/Sort then the fields populate and also an Erg msg shows: "The value you entered isn't valid for this field etc, etc". Click the Ok and all is find. I do not any filter code anywhere that I can find, No events to filter/Sort, no code etc, the only sorts are in the various queries. Anyhelp much appreciated Dave How do you open the form? Directly from the main object window? If so, and you've checked the form for attached code and filters, check the underlying table. The data or its structure may be corrupt. Perform a compact and repair, search for a bad record or data point, etc. HTH >I open a form and it is blank of data except that the record selector in the >primary key field (Rec ID) shows AutoNumber. Then when I select Remove [quoted text clipped - 7 lines] >Anyhelp much appreciated >Dave |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.