Unwanted filter

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top