Access crashes when navigating a filtered selection

  • Thread starter Thread starter Manic Grin
  • Start date Start date
M

Manic Grin

When I right click on a field and apply a filter (for example to find
all the orders placed by a certain customer) the filter applies fine.
However, when the navigation buttons are clicked to navigate through
these filtered records, Access crashes.

Any ideas?

TIA.
 
This behaviour indicates a corruption in Access, either of the form or of
the table indexes.

First: Tools | Database Utilities | Repair.

If that doesn't prevent the issue, open the table that this form is based on
in design view. If the field is indexed, removed the indexes. Save, Compact,
and try the form again. You can add the index again if this solves the
problem.

If that doesn't solve the issue, try opening the table (or query) that the
form is based on directly. Apply the same filter. Does the table/query
crash? If so, the fault is with the table/index. If not, the fault is with
the form.

Create a new database, and import the objects except the problem one. If the
problem one is a table, delete all the relationships it is involved in,
delete its indexes, and then import it. After you check it works, you can
recreate its indexes and relations. If the problem is with the form, create
the form from scratch, or import from an old backup.
 
I suspect it is an error with the form as all was well until I did
some modifications to the layout of the form which is when the
problems arose.

Thanks.
 
Back
Top