Filter problem- hard to get rid of

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
 
V

Van T. Dinh

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.
 
Top