Unwanted filter

D

Dave

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
 
K

kingston via AccessMonster.com

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
 
Top