Filter problem- hard to get rid of

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

When I open my 2003 Dbase the main form is blank of data, when I select
"Remove Filter/Sort" then a err msg comes up " The value you entered is not
valid for this field", I cl OK and data appears in all fields.
How do I get rid of the preset ?? filter/Sort ?. I have searched all my
other code but cannot see any Filter/Sort code. the "allow filter" is set to
yes, but no code that I can find.
any help please?
Dave
 
Do you open the Form by code or just through the Forms Container of the
Database window?

If you open the Form by code, check the OpenForm statement in your code
which as the Filter argument as well as the WhereCondition argument that set
the filtering on the Form.

You may also need to check the Filter Property in the Design View of the
Form. However, this Filter is not activated unless your code set the
FilterOn to True.
 

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

Similar Threads

Unwanted filter 1
Unwanted Filter ?/ 1
Disallow field sorting by users 1
2007 Forms - Quick Filters not working 5
Cant get rid of a filter 2
Filter by form in linked table database 2
Using DSUM to get running total on a filtered form 0
Form Filter will not delete 2

Back
Top