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
|
|||
|
|||
Unwanted 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 |
#2
|
|||
|
|||
Unwanted filter
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 Dave wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200701/1 |
Thread Tools | |
Display Modes | |
|
|